1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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?

Question Posted / vamsi

Answers were Sorted based on User's Feedback



i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates l..

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

Post New Answer

More Data Stage Interview Questions

What is a ds designer?

0 Answers  

hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer

1 Answers   Polaris,

How do you find the number of rows in a sequential file?

1 Answers  

What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?

5 Answers   SLK Software,

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables?chandu how can i implement scd typ1 and type2 in both server and in parallel?chandu field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the ,inthe fields?

2 Answers  




eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.

4 Answers   Wipro,

Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?

3 Answers   TCS,

How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

0 Answers   Wipro,

in datastage interview qustion source target ------- ------- 12345 1 2 3 4 5

3 Answers   IBM, YCS,

I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?

3 Answers   Virtusa,

What is use Array size in datastage

0 Answers  

how does work server jobs?

1 Answers  

For more Data Stage Interview Questions Click Here
Categories