Interested to Buy Any Domain ? << Click Here >> for more details...
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..........?
- 8 Answers
- 12956 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
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What are the types of views in datastage director?
Difference between server jobs & parallel jobs?
What is process model?
How do you start developing a datastage project?
Differentiate between operational datastage (ods) and data warehouse?
Differentiate between validated and Compiled in the Datastage?
What are the different plug-ins stages used in your projects?
what is flow of project?
Where do you see different stages in the designer?
What is the difference between datastage and datastage tx?
What are the steps needed to create a simple basic datastage job?
How complex jobs are implemented in datstage to improve performance?
How and where you used hash file?
What is difference between symmetric multiprocessing and massive parallel processing?
