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
- 11037 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
What are connected or unconnected transformations?
What is meant by a domain?
differences between service based and product based?
Design a mapping to load the cumulative sum of salaries of employees into target table?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What is the sequence generator transformation in informatica?
What is event and what are the tasks related to it?
What is the scenario which compels informatica server to reject files?
What can we do to improve the performance of informatica aggregator transformation?
What is a connected transformation?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
what is the -ve test case in your project.
What is Data Caches size?
How to extract the informatica rejected data?
explan ur project architecture?
