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


Please Help Members By Posting Answers For Below Questions

Define enterprise data warehousing?

612


What are the components of the workflow manager?

608


What is a code page?

687


What is the difference between informatics 7x and 8x and what is latest version?

524


What is the use of an aggregator cache file?

663






Different qualification between a related rotate toward the sky and isolates look upward?

529


How we can use union transformation?

581


How do you handle two sessions in Informatica

641


What is transformation?

631


if we have a delimiters at unwanted places in a flat file how can we over come those.

1536


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1455


Explain about Informatica server process that how it works relates to mapping variables?

596


How to do unit testing in informatica? How to load data in informatica ?

625


What are the settings that you use to configure the joiner transformation?

588


what is the size of your data warehousing?

1649