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 / me
seq----> copy
from copy stage one link to aggregator apply count rows option ---> filter (on count rows output 1 ) send as reference to look up below
from copy stage second link to lookup
apply filter
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the datastage parallel extender (px) or enterprise edition (ee)?
How and where you used hash file?
What is the purpose of pivot stage?
What are the partitioning techniques available in link partitioner?
What all are the different way to run a job?
What are the various kinds of containers available in datastage?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
What are the different layers in the information server architecture?
What is the difference between hashfile and sequential file?
On which Dimension Table you implemented SCD Type in your Project
What is difference between server jobs & parallel jobs?
What are the different kinds of views available in a datastage director?
Notification Activity
What is the difference between an operational datastage and a data warehouse?
Distinguish between informatica & datastage. Which one would you choose and why?