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..........?
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
Terminate Activity
Explain connectivity between datastage with datasources?
What are the different type of jobs in datastage?
How complex jobs are implemented in datstage to improve performance?
What are the functionalities of link collector?
What is job control?
What is the difference between passive stage and active stage?
what are the devoleper roles in real time? plz tell i am new to datastage....
How many types of views are there in a datastage director?
What are routines in datastage? Enlist various types of routines.
Define meta stage?
What are the various kinds of containers available in datastage?
How a server job can be converted to a parallel job?
How do you start developing a datastage project?
What all are the different way to run a job?