Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 10820 Views
- CTS, I also Faced
- E-Mail Answers
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
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is confirmed fact in dataware housing?
update strategy transformation in informatica
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
how we can load rejected record's at run time?(not through bad files)
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
hi real timers . iam waiting for ur reply regarding ETL TESTING
How can a transformation be made reusable?
What is rank transformation in informatica
How many types of sessions are there in informatica.please explain them?
Differentiate between reusable transformation and mapplet.
What is a router transformation?
In warehouses how many schemas are there?
What is the surrogate key?
What is the difference between source qualifier transformations source filter to filter transformation?
