How we can get unique records into one target table and
duplicate records into another target table??

Answer Posted / bala

in router count(*)=1 for good record

count(*)>1 for duplicate record

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the meaning of up gradation of repository?

1393


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

9168


What is the status code in stored procedure transformation?

687


What is a joiner transformation and why it is an active one?

580


According to his methodology what all you need before you build a datawarehouse

1191






When do you use sql override in a lookup transformation?

591


How to create Target definition for flat files?

756


What do you mean incremental aggregation?

625


Target increases every day even though no new record was inserted

1111


Define mapping and session?

587


Briefly explain the aggregator transformation?

604


tell me the rules and responsblites in our project(my project is development)

1505


Explain the different kinds of facts.

566


Explain the types of lookup transformation?

577


Explain pushdown optimization and types in informatica

672