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
- 13501 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / vinod upputuri
In order to collect the duplicate values:
first cal the count output col in aggregator stage
group by col.
aggregator type: count rows.
count output col..
next, use the filter stage to separate the multiple occurrence.
finally, use the join stage or lookup stage to map the two
tables join type INNER ..
then u can get the desired output..
| Is This Answer Correct ? | 14 Yes | 1 No |
Post New Answer View All Answers
What is use Array size in datastage
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
Terminate Activity
Notification Activity
EXPLAIN SCD
How a server job can be converted to a parallel job?
What all are the different way to run a job?
What is size of a transaction and an array means in a datastage?
Where do you see different stages in the designer?
Where the datastage stored his repository?
how to add a new records into source?
What is difference between join, merge and lookup stage?
Define orabulk and bcp stages?
Give an idea of system variables.
