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
wf dont have integration severances how you can run?
What is complex mapping?
What is workflow? What are the components of workflow manager?
How to elaborate powercenter integration service?
How to delete duplicate row using informatica?
How an expression transformation differs from aggregator transformation?
What are the types of data warehouses?
update strategy transformation in informatica
What is the session task and command task?
How does a rank transform differ from aggregator transform functions max and min?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How can we update a record in the target table without using update strategy?
What is the need of etl tools?
What is the difference between source qualifier transformations source filter to filter transformation?
On which transformations you created partitions in your project?