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
- 17886 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / d.bharath
Take source and copy,aggregate,transformer and lookup,
1) give one copy output link to aggr,
2)In arggr perform count rows,
3)And in transformer check constrains count>1,count>2
4)And lookup the result of count>2 with the second output
link of copy stage.the you will get the all repeated rows
into on one output dataset.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the enhancements made in datastage 7.5 compare with 7.0?
How to implement complex jobs in data stage?
What is ibm datastage?
How one source columns or rows to be loaded in to two different tables?
Define Merge?
What is meta stage?
What is "fatal error/rdbms code 3996" error?
AGGREGATOR default datatype
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
How we can covert server job to a parallel job?
What is the use of datastage designer?
What are the functionalities of link collector?
What is the difference between server job and parallel jobs?
What are stage variables and constants?
Lookup constraints
