i have a table
col1
10
20
30
40
10
20
50
my requirement is how to retrive only duplicates like
10
10
20
20
like this how it's possible in SQL?
Answer Posted / geetha
To achive the same in datastage we can use aggregator stage.
Check the below link
http://mydatastage-notes.blogspot.in/p/aggregatorstage.html
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the components of ascential data stage?
Can we use target hash file as a lookup ?
What all are the different way to run a job?
what is 'reconsideration error' and how can i respond to this error and how to debug this
How will you move hashed file from one location to another location?
root tree will find which is server job and which is parallel job?
What are stage variables, derivations and constants?
How a routine is called in datastage job?
how to sort two columns in single job in datastage.
What is active and passive stage?
Differentiate between operational datastage (ods) and data warehouse?
How do you register plug-ins?
what is use of SDR function?
How you Implemented SCD Type 1 & Type 2 in your project?
what is the custome stage in datastage? how can we impliment that one? plz tell me