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
- 21582 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
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What are the different layers in the information server architecture?
How can we improve performance of data stage jobs?
sed,awk,head
State the difference between an operational datastage and a data warehouse?
Why do you need stage variables?
Name the command line functions to import and export the DS jobs?
Describe routines in datastage? Enlist various types of routines.
Explain entity, attribute and relationship in datastage?
How can you write parallel routines in datastage PX?
Define orabulk and bcp stages?
How a source file is populated?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
what is repositery?
What are the types of containers in datastage?
