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
- 21279 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 are the primary usages of datastage tool?
What are sequencers?
What is active and passive stage?
Is it possible to query a hash file?
To see hidden files in LINIX?
What are orabulk and bcp stages?
What is datastage engine?
How many Key we can define in remove duplicate stage?
What are the repository tables in datastage?
what is ds administrator used for?
How a routine is called in datastage job?
Describe stream connector?
What are the types of hashed files in data stage
What are some different alternative commands associated with "dsjob"?
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?
