Interested to Buy Any Domain ? << Click Here >> for more details...
2,can we insert duplicate data with dynamic look up cache,if
yes than why and if no why?
- 2 Answers
- 8727 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 |
What is exclusive and normal mode for repository services?
When we are using Dynamic Cache,which options we will select in session level?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
what are objects in data warehouse?
Where is the cache stored in informatica?
What is difference between stored procedure transformation and external procedure transformation?
What are the restrictions of union transformation?
What is the meaning of up gradation of repository?
What is the Rankindex in Ranktransformation?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Can we create a Integration service without a Repository service and vice versa?
What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?
Teradata 
