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,

---

If you want to use the same piece of code in different jobs, how will you achieve it?

0 Answers  

---

on how many columns we can perform aggregation in the aggregator stage?

2 Answers   Reliance,

---

how do u convert date in 20-12-07 to dec-20-2007 or 20-dec- 2007 or 20-dec-07 in parallel

3 Answers   Wipro,

---

tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?

3 Answers   Infotech,

---

What is the difference between orabulk and bcp stages?

0 Answers  

---

What is the version control how can i apply this in DataStage can any one tell me the anser

4 Answers   IBM,

---

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

0 Answers  

---

How can we improve the performance in datastage?

0 Answers  

---

what is repositery?

0 Answers   IBM,

---

How to perform incremental load in datastage?

0 Answers  

---

how to retrive the max(sal),deptno,empno in datastage?

13 Answers   Polaris,

---