Remove Duplicates from target File
Posted: Fri Aug 29, 2008 12:17 am
I need to remove duplicates for example
I am gettin this as the output
aaa bbb ccc
aaa bbb ccc
aaa ddd fff
aaa ddd fff
Actuall output file should look like
aaa bbb ccc
aaa ddd fff
I have used the following stages
database1->Hash file
-
-
-
database2-> Sorter-> Transformer-> OUTPUT File..
Still i am not able to remove duplicate. Please advice me on this.
As i am new to datastage and i have saw some post specifies use Use Stage variable.
But how to work on stagevariable on this. or Advice some other solution
I am gettin this as the output
aaa bbb ccc
aaa bbb ccc
aaa ddd fff
aaa ddd fff
Actuall output file should look like
aaa bbb ccc
aaa ddd fff
I have used the following stages
database1->Hash file
-
-
-
database2-> Sorter-> Transformer-> OUTPUT File..
Still i am not able to remove duplicate. Please advice me on this.
As i am new to datastage and i have saw some post specifies use Use Stage variable.
But how to work on stagevariable on this. or Advice some other solution