2,can we insert duplicate data with dynamic look up cache,if
yes than why and if no why?
- 2 Answers
- 7994 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ankur saini er.ankur861@gmail.
we use dynamic lookups in case we have duplicates in source
and source says that they cnt remove them as per
requirement ...in that case we have to settle for:
say we have a reocrd id=1 , name=a
id=1 , name=b
so depending upon the PI id this is a duplicate so using
dynamic lookup when firts record comes the lookup cache
will have id=1 , name=a
again will duplkicate row will come then it gets updated to
id=1 , name=b
so finally only last record from the quplicates will be
lloaded in the target
| Is This Answer Correct ? | 2 Yes | 0 No |
Difference between Target-based loading and constraint-based loading?
Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how
Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?
What are the different ways to implement parallel processing in informatica?
tell me about your project functionality
Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer
How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.
What is the difference between SOURCE and TARGET BASED COMMITS?
My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?
How to go to the older version for a mapping?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Teradata 
