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
- 21584 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 |
Have you have ever worked in unix environment and why it is useful in datastage?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
what is advantages of snowflake when it is used?
what is initial load and incremental load
How do you design PX Routines ?
SOURCE LIKE I_D,F1,F2 --------- 100,N,Y 100,N,N 100,Y,N 101,Y,Y 101,N,Y 102,Y,N 103,N,N 104,Y,Y 105,N,N 106,N,Y 102,N,Y 105,Y,Y O/P LIKE ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y
hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz
How did you reconcile source with target?
My source having following data as below, AB1 Aim2 Abnv5 1An8bx and my question is i need the Datastage job the following as in my target 000AB1 00Aim2 0Abnv5 1An8bx Please help me to achive this.
describe the Steps to confiure a Qlogic switch
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?
Where do you see different stages in the designer?
Teradata 
