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?

Answer Posted / vamsi

HI,
ANY ONE TELL ME HO WE CAN DONE THIS IN DATASTAGE?

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between account and directory options ?

620


Can you explain tagbatch restructure operator?

700


What is the different type of jobs in datastage?

570


On which interface you will be working as a developer?

635


Whats difference betweeen operational data stage (ods) and data warehouse?

669






How can we improve the performance in datastage?

650


How a server job can be converted to a parallel job?

619


how to write server Routine coding?

1665


What are the main differences you have observed between 7.x and 8.x version of datastage?

622


What is the importance of the exception activity in datastage?

624


How do u convert the columns to rows in datastage?

692


What is a folder? Difference types of stages?

629


Different ways a project can be moved to production ?...example ….export-import and Version control.

1933


What are the differences between datastage and informatica?

570


What is the sortmerge collector?

662