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,

---

Why do we use exception activity in Datastage?

0 Answers  

---

If seg file having 10 records ex:eid 1 2 " " 10 if oracle database having 100 records ex:eid 1 2 " " 100 how to delete matched records permenently from oracle database using datastage ?

5 Answers   Infotech,

---

Define Data Stage?

0 Answers  

---

Enlist various types of routines in datastage.

0 Answers  

---

Notification Activity

0 Answers   CTS,

---

Unix command to view the data in a dataset

2 Answers   IBM,

---

What is meta stage?

0 Answers  

---

diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?

2 Answers   TCS,

---

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

0 Answers   Cap Gemini, TCS,

---

Can you implement SCD2 using join, transformer and funnel stage?

0 Answers   Cognizant,

---

what is the difference between the active datawarehouse and datawarehouse

1 Answers   TCS,

---