Page 1 of 1

Remove duplicate and reject the duplicate records

Posted: Tue Apr 27, 2010 3:25 am
by mayura
Source-- file having dulicate records
Target--Need only unique records

Conditon--Need to remove dulicate records and paas the unique records and reject the dulicate records into reject link.


Please help me out with this scenario.

Thx,
Mayura :lol:

Posted: Tue Apr 27, 2010 3:48 am
by dr.murthy
Use sort stage and apply the property create cluster key col is true , then you can get the aditional fileld with 0 and 1 after that you can filter both unique and duplicate records