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
- 8584 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain why we use partitioning the session in informatica?
Why union transformation is an active transformation?
Parameter and variable differences
How many types of sessions are there in informatica.please explain them?
Mention few power centre client applications with their basic purpose?
Explain the difference between mapping parameter and mapping variable?
Write the prerequisite tasks to achieve the session partition?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is dimensional table?
Can you use flat files in Mapplets.
What are mapplets? How is it different from a Reusable Transformation?
list out all the transformations which use cache?
Which version configuration tool used in ur project?
Describe the impact of several join conditions and join order in a joiner transformation?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
