Remove Duplicates

Hi,

  We have the remove duplicate stage in the pararllel extender enterprise edition using that we eill remove the duplicates
                                       (or)
   Using copy stage we will remove the duplicates.

make the wanted column as key column in target stage.
Then it will remove the duplicates.
 

What is the process to remove the duplicates in copy Stage?

In parallel jobs by using sort stage Or Remove Duplicates stage We can remove duplicate records 


Regards
Suri

There are several ways in removing the duplicates depends on the data u have..

have to use stage variables effectively to remove the duplicates.

use rowprevious compare function.. which is available in datastage...


Regards
Sriks