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 / varaprasadsams
Hi Dear,
The above query is 100% correct, i tried.
comming to datastage, source-sort stage-transformer-trg.
in sort stage create keychange column , in tfm choose constraint as zero...sure u wil get...
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is ibm datastage flow designer?
What are the components of ascential data stage?
What is the difference between hashfile and sequential file?
On which interface you will be working as a developer?
What a datastage macro?
what is the use of materialized view?
If you want to use the same piece of code in different jobs, how will you achieve it?
How a routine is called in datastage job?
AGGREGATOR default datatype
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
Can you highlight the main features of ibm infosphere information server?
Is the value of staging variable stored temporarily or permanently?
What is active and passive stage?
What is the roundrobin collector?
Describe link sort?