2,can we insert duplicate data with dynamic look up cache,if
yes than why and if no why?
- 2 Answers
- 7772 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
What is persistent lookup cache?
Briefly define reusable transformation?
Enlist the various types of transformations.
How can we improve session performance in aggregator transformation?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What is deployment group?
How do you use reject loader.
Explain the scenario which compels informatica server to reject files?
Enterprise data warehouse your projects phase by phase explain?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is expression transformation?
Clarify the aggregator change?
How identifying bottlenecks in various components of informatica and resolving them?
scenario where i can use only concurrent execution of workflow.
