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 / leo gilbert

Have a lookup to table T1 (should be dynamic one). If the
record already exists in T1 (i.e. duplicate) then route to
T2 else route to T1

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to extract sap data using informatica?

581


What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

1871


What is informatica?

657


wf dont have integration severances how you can run?

1516


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1471






What is the difference between Active and Passive transformation?

609


Which development components of informatica have the highest usage?

567


What are the differences between oltp and olap?

527


What is workflow manager?

552


Mention a few design and development best practices for informatica?

536


is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

602


Why union transformation is an active transformation?

630


Explain pushdown optimization $pushdownconfig parameter - informatica

670


Differences between connected and unconnected lookup?

585


What are the types of presistent cache in look up tr.

1523