how to remove duplicates in source

Formally known as "Mercator Inside Integrator 6.7", DataStage TX enables high-volume, complex transactions without the need for additional coding.

Moderators: chulett, rschirm

Post Reply
vijaya
Participant
Posts: 15
Joined: Mon Jul 24, 2006 2:51 am

how to remove duplicates in source

Post by vijaya »

please let me know how to remove duplicates while transfering source to target. i know that v have to use lookup stage but where to give condition .
suppose it is in this format





seqfile------------transformer------------target
\ \
\ \
\ \
lkp stage rejects







i mean where to do look up and how to use conditions
please let me know

thanks in advance
balajisr
Charter Member
Charter Member
Posts: 785
Joined: Thu Jul 28, 2005 8:58 am

Post by balajisr »

Do a search. This has been covered many times.
us1aslam1us
Charter Member
Charter Member
Posts: 822
Joined: Sat Sep 17, 2005 5:25 pm
Location: USA

Post by us1aslam1us »

Hi Vijay,

Are you working on TX,PX or server? You have posts in each forum i believe. Post specific questions in the appropriate forum.

Sam
Post Reply