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
- 13209 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
Lookup constraints
Highlight the main features of datastage?
What is quality stage?
how to implement scd2 in datastage 7.5 with lookup stage
Can you explain how could anyone drop the index before loading the data in target in datastage?
How do you import and export the datastage jobs?
What are the types of containers in datastage?
What is datastage?
What are the different layers in the information server architecture?
What is datastage engine?
in oracle target stage when we use load option and when we use upsert option?
What is the differentiate between data file and descriptor file?
What are the enhancements made in datastage 7.5 compare with 7.0?
How many types of sorting methods are available in datastage?
Whats difference betweeen operational data stage (ods) and data warehouse?
