How we can get unique records into one target table and
duplicate records into another target table??
Answer Posted / durgaprasad
data flow for this one is:
sq-->Aggregater-->Router-->target
in aggregater t/r take 2 output ports and give condition like
uniqe_port---->count(*)=1
duplicate_port--->count(*)>1
connect this one router and in router take 2 groups and
give condition like
uniqgroup=uniqe_port
duplicategroup=duplicate_port
and connect that groups to target
Is This Answer Correct ? | 15 Yes | 28 No |
Post New Answer View All Answers
What are the types of lookup transformation?
Which means the first record should come as last record and last record should come as first record and load into the target file?
How can we remove the duplicates from flat file source?
Differentiate between joiner and lookup transformation?
What is repository manager?
what are 3 tech challenges/ common issues you face?
What is union transformation?
Explain sessions and how many types of sessions are there?
generate date / time dimension in informatica
explain one complex mapping with logic? sales project?
What is rank transform?
What are connected or unconnected transformations?
What are the data movement modes in informatica?
Explain how to import oracle sequence into informatica?
wat are deployement groups in informatica, how it will be used for developers