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
Define enterprise data warehousing?
What are the components of the workflow manager?
What is a code page?
What is the difference between informatics 7x and 8x and what is latest version?
What is the use of an aggregator cache file?
Different qualification between a related rotate toward the sky and isolates look upward?
How we can use union transformation?
How do you handle two sessions in Informatica
What is transformation?
if we have a delimiters at unwanted places in a flat file how can we over come those.
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Explain about Informatica server process that how it works relates to mapping variables?
How to do unit testing in informatica? How to load data in informatica ?
What are the settings that you use to configure the joiner transformation?
what is the size of your data warehousing?