Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 11 Answers
- 20858 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 stages in datastage?
What are the types of containers in datastage?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
How do you generate sequence number in datastage?
Differentiate between data file and descriptor file?
Explain usage analysis in datastage?
Differentiate between odbc and drs stage?
Define APT_CONFIG in Datastage?
Explain the importance of surrogate key in data warehousing?
What are the primary usages of datastage tool?
Can you explain players in datastage?
How can you write parallel routines in datastage PX?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
How can we improve performance of data stage jobs?
