Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - How can i catch the Duplicate Rows From Sorter Trans in a Separate Target Table ?




442
views
asked marvit September 20, 2014 07:59 AM  

How can i catch the Duplicate Rows From Sorter Trans in a Separate Target Table ?


           

1 Answers



 
answered By vishnoiprem   0  
When you use 'Select Distinct' option , the Sorter Transformation discards the duplicate records.
If you want to trace out the duplicate records, then send the sorted data into Expression Transformation. Add a new variable and compare the variable with the input data. If the data matches then flag the record or else pass the 
default row.And load all the flagged records into a separate table
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert