Page 1 of 1
want to pass unique and dup record seperately
Posted: Tue Jun 14, 2011 7:05 am
by deesh
Hi,
Any one can suggest me
how to pass single input file unique and duplicate records seperately in different outputs without usage of transformer stage.
Posted: Tue Jun 14, 2011 7:45 am
by DSguru2B
Look into sort stage and filter stage.
Posted: Tue Jun 14, 2011 3:00 pm
by ray.wurlod
Use a fork join design and a downstream filter on the count. The solution has been posted previously on DSXchange.
Re: want to pass unique and dup record seperately
Posted: Tue Jun 14, 2011 11:23 pm
by deesh
Hi All,
Problem was solved. see the below process.
source file---> select option in Sort stage (Create Key change column (True)), it produce unique records in "1", dup records in "0",----> Filter stage take two output links one for dup, second for unique records filter based on create key column basis.
If any one not understand, let reply to me i will give more informaion.