Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

Answers were Sorted based on User's Feedback



suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n d..

Answer / 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

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n d..

Answer / 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

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n d..

Answer / laksh

You can do this in one mapping by using sorter and then
expression transofrmation ..in Expression use 3 variables ..
1 Current 2 previous 3 route..
if prevous = current sent to table 2 else 1.

Is This Answer Correct ?    2 Yes 2 No

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n d..

Answer / balaramesh

using constraint based transformation

Is This Answer Correct ?    1 Yes 5 No

Post New Answer



More Informatica Interview Questions

have u done any performance tuning? how u ll do?

0 Answers   IMB, TCS,


What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

0 Answers   CTS,


What is workflow variable? When we use workflow variable? Can any one explain me with one example???

2 Answers   TCS,


What is confirmed dimension and fact?

7 Answers  


How do you join more than 3 flat files in informatica?

1 Answers   ITC Infotech,






What are the different threads in DTM process?

2 Answers  


What are the options in the target session of update strategy transsformatioin?

2 Answers  


What is the meaning of decode in informatica?

0 Answers  


source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?

5 Answers   Polaris,


i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario

4 Answers   Polaris,


how do the project develops? pls specify right from the start to end in step by steps.

0 Answers   ITC Infotech,


task is running successfully but data is not loded why?

2 Answers  






Categories