Search found 1 match

by mani10487
Tue May 11, 2010 1:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: flags for duplicate records
Replies: 4
Views: 2162

flags for duplicate records

hi/hello,

how to perform flag values for duplicate records..

for example if i have
empid,sal,city
100,1000,chn
101,2000,hyd
100,3000,pune in i/p stage


i should get

empid,sal,city,flag
100,1000,chn,1
101,2000,hyd,1
100,3000,pune,0

in the output.. can anyone tell me how to do this..