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?
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 |
IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?
What are the unit test cases you used in your project?
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
I have file with empid,empname and I want to load these two fields along with sal in my target 1)salary must be same for all the records 2)I want pass the salary at run time
1.What is a delta record? How you will read it? 2.What are the different types of sorting?
what is time dimension? and how to populate time demension
Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.
What are the types of views in datastage director?
Explain the importance of surrogate key in data warehousing?
how to capture rejected data by using join stage not for lookup stage. please let me know
what is the difference between == and eq in UNIX shell scripting?
how to do pergformence tuning in datastage?