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 a joiner transformation and why it is an active one?
What is persistent lookup cache?
What are the limitations of joiner transformation?
Informatica Checkpoints
what is Active lock explain
Write the prerequisite tasks to achieve the session partition?
What is a transaction control transformation?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How an expression transformation differs from aggregator transformation?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is the difference between informatics 7x and 8x and what is latest version?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Write the unconnected lookup syntax and how to return more than one column.
What is an expression transformation?
How is union transformation utilized?