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
Explain why we use partitioning the session in informatica?
What is pmcmd command?
Explain the scenario which compels informatica server to reject files?
Explain sessions. Explain how batches are used to combine executions?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is the difference between a repository server and a powerhouse?
What are the advantages of informatica?
What is a repository manager?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
waht type of interface is used for testing the data in informatica
What is the Rank index port in Rank transformation?
can u give example for factless fact table
How to generate sequence numbers without using the sequence generator transformation?
What is flashback table ? Advance thanks