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
- 11192 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 do think which one is the better joiner or look up?
Explain how many types of dimensions are available in informatica?
Explain about cumulative Sum or moving sum?
How to Create a folder using pmrep command?
Define the various join types of joiner transformation?
What is a surrogate key?
What are the new features of informatica 9.x at the developer level?
Tell me about Propagate functions in informatica
Define mapplet?
Explain the scenario which compels informatica server to reject files?
How to improve the performance of a session using sorter transformation?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
explain one complex mapping with logic? sales project?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What is pmcmd command?
