Source is a flat file and want to load unique and duplicate
records separately into two separate targets; right??
Answer Posted / ankit kansal
Hi,
What i have understood after seeing your problem is like if your source contains 1,2,1,2,3 then only 3 is taken as unique and 1,2 will be considered as duplicate values.
SRC->SQ->SRT->EXP(to set flags for dup)->ROUTER->JOINER->EXP->RTR->2TGTS
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Parameter and variable differences
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Enlist the advantages of informatica.
What is rank transformation in informatica
What is event and what are the tasks related to it?
can we override a native sql query within informatica? How do we do it?
How do you remove duplicate records in informatica? And how many ways are there to do it?
can u give example for factless fact table
What is sorter transformation?
Why update strategy and union transformations are active? Explain with examples.
How identifying bottlenecks in various components of informatica and resolving them?
my source is junk data how will u remove that junk data by using unix please any one replay me
How do you load alternate records into different tables through mapping flow?
What are the types of schemas we have in data warehouse.
How do we call shell scripts from informatica?