how to duplicates from expression transformation without
using sorter before that



how to duplicates from expression transformation without using sorter before that..

Answer / nagaraju bhatraju

1.)
we can distinguish between unique and duplicate records in
informatica by using forward reference technique ,
in the sense , we can store the previous rec key value in
Variable_Port and can be compared with the previous rec key
value , but Data has to be come in sorted order on that key
column , for that we should use sorter transformation.

once if you find the duplicate rec by comparing , you can
flag that rec as dulicate and you can divert it to other
target.

2.) with out using sorter

in order to collect only unique records for flat file ,
just use aggregator before exp transformation, and check
group by on the key column where you are expecting
duplicate records. so you will get only unique records and
duplicate records will be eliminated.

Is This Answer Correct ?    15 Yes 1 No

Post New Answer

More Informatica Interview Questions

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

0 Answers  


What is the difference between a connected look up and unconnected lookup?

0 Answers  


WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com

2 Answers   TCS,


hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?

4 Answers  


in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?

11 Answers   L&T,






have you developed documents in your project? and what documents we develop in realtime?

2 Answers   IBM,


if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?

9 Answers   BirlaSoft, Genpact, L&T, Syntel,


Enterprise data warehouse your projects phase by phase explain?

0 Answers   Cap Gemini,


Design time, run time. If you don't create parameter what will happen

0 Answers  


What is the benefit of session partitioning?

0 Answers  


diffrence between command task and control task

1 Answers   iNautix,


in which situations do u go for sequence generator ?

2 Answers   TCS,


Categories