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
- 21258 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 is ibm datastage flow designer?
What is the purpose of pivot stage?
How do you import and export data into datastage?
Which algorithm you used for your hashfile?
How to read multiple files using a single datastage job if files have the same metadata?
What are the various kinds of the hash file?
Is possible to create skid in dim,fact tables?
How rejected rows are managed in datastage?
What is datastage?
What are the different types of lookups in datastage?
what is the difference between == and eq in UNIX shell scripting?
What are the different layers in the information server architecture?
Define project in datastage?
how to export or import the jobs in .ISX file
how to run a sequential file stage in parallel if the stage is used on the TARGET side
