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
- 21308 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Describe routines in datastage? Enlist various types of routines.
1. How many People are part of your Team? 2. Explain how you create jobs or flow of project? 3. Join Stage vs Lookup vs Merge Stage 4. Summation scenario based question - How you find sum of salary for a specific employee (Explain stages and flow of job)? 5. Explain Remove duplicates stage ? Can you do sort in this stage? 6. SQL Questions - Joins - Types, Difference between Join and Union 7. Unix Questions - How you run the Job, How you list all jobs in project 8. Explain Environmental Variables? 9. SQL Scenario - If you have 3 Identical record in a Table, Ex: 1, Ram, Xyz; 1, Ram, Xyz; 1, Ram, Xyz; Delete only 2 of the records and keep only 1 using the Delete query. How you will you do this?
To see hidden files in LINIX?
how to load meta data
How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?
Can you explain players in datastage?
i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
what r the stages mostly used in realtime scenarios
what is normalization and denormalization
Why fact table is in normal form?
my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 4 5 6 7 8 9 like this how we can get?
Teradata 
