suppose if we have dublicate records in a table temp n now
i want to pass unique values to t1 n dublicat values to t2
in single mapping?how
Answer Posted / vivekk
Src-->SQ-->AGG-->RTR--->TG1 & TG2
In AGG Txn, take count(columns), then pass this port to RTR Txn which has Unique and Duplicate group. Unique group will be having condition count = 1 whereas for Duplicate group has condition count > 1. Pass these to TGT instance 1 and 2.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Can informatica load heterogeneous targets from heterogeneous sources?
What is main use of mapplet?
Can we create multiple integration service on single repository?
What is meant by lookup transformation? Explain the types of lookup transformation?
What are Dimensional table?
What is rank transform?
how to load rows into fact table in data warehouse
What is the need for an etl tool?
What is a standalone command task?
What does “tail –f” command do and what is its use as an Informatica admin.
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What are the components of the workflow manager?
Informatica settings are available in which file?
difference between informatica 8.1.1 and 8.6