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
How many types of stage?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
how to delete one row in target dataset
What are the repository tables in datastage?
Define APT_CONFIG in Datastage?
What is the sortmerge collector?
Explain the importance of surrogate key in data warehousing?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What are the components of ascential data stage?
In Datastage, how you can fix the truncated data error?
What are the steps needed to create a simple basic datastage job?
Why do we use link partitioner and link collector in datastage?
What is process model?
What are the job parameters?
What are the processing stages?