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
- 21261 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 is the flow of loading data into fact & dimensional tables?
What are the difference types of stages?
how many rows sorted in sort stage by default in server jobs
What steps should be taken to improve Datastage jobs?
Explain Quality stage?
whom do you report?
How can we improve the performance in datastage?
What is difference between symmetric multiprocessing and massive parallel processing?
What are the different options associated with dsjob command?
How to manage date conversion in Datastage?
What is ibm datastage flow designer?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
Can you explain how could anyone drop the index before loading the data in target in datastage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Can you highlight the main features of ibm infosphere information server?
