- aggregator - seq. file

one file contains
col1
100
200
300
400
500
100
300
600
300
from this i want to retrive the only duplicate like this
tr1
100
100
300
300
300 how it's possible in datastage?can any one plz explain
clearley..........?

Question Posted / sudheer

8 Answers
13203 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / sudheer

- aggregator -
seq. file - copy join - filter - seq.op

in arrg - cnt rows
in join - left outer join - left as seq.file data
in filter - where cond. - cnt>1

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

sed,awk,head

1446

How to manage date conversion in Datastage?

1117

How do you register plug-ins?

955

Which algorithm you used for your hashfile?

1164

How to perform incremental load in datastage?

1180

Difference between server jobs & parallel jobs?

1058

How the ipc stage work?

1113

How do you remove duplicate values in datastage?

1137

how to sort two columns in single job in datastage.

2884

what is the use of materialized view?

1553

CHANGE CAPTURE

1292

What is a merge in datastage?

1246

how do u catch bad rows from OCI stage? And what CLI stands for?

2787

Define meta stage?

1186

What is the importance of the exception activity in datastage?

1055