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
- 8716 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
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What is native users?
How are the sources and targets definitions imported in informatica designer?
What is the commit type if you have a transaction control transformation in the mapping?
difference between informatica 8.1.1 and 8.6
Separate from an archive server and a powerhouse?
Under which circumstances, informatica server creates reject files?
how many types of dimensions are available in informatica?
what is diff b/t sorter t/r and agg have the option sorter property...
Explain sql transformation in script mode examples in informatica
How identifying bottlenecks in various components of informatica and resolving them?
Explain why we use partitioning the session in informatica?
How to use procedural logic inside infromatica?
What are the restrictions of union transformation?
What is a grid in Informatica?
