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,

---

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   Cap Gemini,

---

How can we do null handling in sequential files?

3 Answers   Reliance,

---

Difference between JOIN,LOOKUP,MERGE?

2 Answers   CTS,

---

how do u capture duplicates through sort & transformer

4 Answers  

---

How many types of views are there in a datastage director?

0 Answers  

---

in one scenario source flat file like Fileld1 00122001550056200568 00256002360014500896 00123004560078900258 00147004560025800256 divide each 5 numbers as one column i.e here i need field1 field2 field3 field4 00122 00155 00562 00568 00256 00236 00145 00896 00123 00456 00789 00258 00147 00456 00258 00256 plz help me....

4 Answers  

---

i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?

2 Answers   L&T,

---

How can remove duplicates in a file using UNIX?

3 Answers   Cap Gemini,

---

Could anyone give brief explanation bout datastage admin

0 Answers  

---

What are the different database update actions available?

1 Answers   HP,

---

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

1 Answers   HCL,

---