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
- 20861 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 |
client know skid info?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
how can you generate sequence number using only the sequential file stage?
I am having two tables called MASTER and DETAIL. I want to insert records to both tables. But one condition is that whenever the insert for MASTER table is success then only the records will inserted into the DETAIL table, otherwise abort the job. How can u design this job?
in datastage interview qustion source target ------- ------- 12345 1 2 3 4 5
what is sparse lookup?
SOURCE CITY NAME1 NAME2 NAME3 NAME4 BGLR HCL CSC IBM TCS TARGET CITY COMPANY BGLR HCL BGLR CSC BGLR IBM BGLR TCS
In Sequential file, how can i split a column into two, and that column contains string datatype. For Example, i have column of string datatype as subedar khaja. Now i want get output as separately with subedar in one column and khaja in second column. How? Coula anybody, solve it?
In my project source data comes from MAINFRAME in files.so,This time data is coming as a binary file...I know for binary data we use Complex flat file stage..I have used it also..but on 'view data' data is not coming correctly..as it in MAINFRAME.give me some ideas..
in aggregator , how can i get the sum in readable format
What are routines in datastage?
how do u catch bad rows from OCI stage? And what CLI stands for?
Teradata 
