How to send duplicates to one target and unique rows to one
target?target is empty
- 9 Answers
- 28050 Views
- Amazon, IBM, Wipro, I also Faced
- E-Mail Answers
Answer Posted / naresh araveti
source> dynamic lookup>router,2 conditions 1. condition
if column_lkp port is null then insert into target1(unqie)
2. condtion if COLumn_lkp port is not null then insert into
target2(duplicates)
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
draw informatica architecture 8.6 ?
what are 3 tech challenges/ common issues you face?
Enlist some properties of sessions.
What are the different ways to implement parallel processing in informatica?
Is stop and abort are same in informatica?
What the difference is between a database, a data warehouse and a data mart?
Briefly describe lookup transformation?
Which transformation should we use to normalise the COBOL and relational sources?
What does update strategy mean, and what are the different option of it?
How does a rank transform differ from aggregator transform functions max and min?
What is a connected transformation?
What is a router transformation?
explain one complex mapping with logic? sales project?
how we can load rejected record's at run time?(not through bad files)
What is expression transformation?
