How you load distinct records into one target and duplicate
records into another target?
Answer Posted / hema
With an Expression transformation flag the 1st record of a
group with some value say "VALID" and flag the other
records of the same group with value say "DUPLICATES". Then
pass this through a router and then to the different
Targets.(1st target - records with VALID flag and in 2nd
target - records with "DUPLICATES" flag)
Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is the difference between a repository server and a powerhouse?
what are 3 tech challenges/ common issues you face?
How are indexes created after completing the load process?
Explain constraint based loading in informatica
what is index?how it can work in informatica
What are the differences between oltp and olap?
What are the new features of informatica 9.x developer?
can u give example for factless fact table
tell me 5 session failure in real time how can you solve that in your project?
Explain what are the different versions of informatica?
Does an informatica transformation support only aggregate expressions?
How many dimensions are there in informatica?
Where can we find the throughput option in informatica?
How to go to the older version for a mapping?
How to join three sources using joiner?