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
- 21306 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
sed,awk,head
what is use of SDR function?
What are constraints and derivations?
What are iconv and oconv?
What are the types of jobs we have in datastage?
What is the purpose of interprocessor stage in server jobs?
What is a ds designer?
how many rows sorted in sort stage by default in server jobs
How you can fix the truncated data error in datastage?
What is the difference between orabulk and bcp stages?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
What a datastage macro?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Difference between in process and inter process?
To see hidden files in LINIX?
