Source Like department_no, employee_name ---------------------------- 20, R 10, A 10, D 20, P 10, B 10, C 20, Q 20, S and Output should be like this department_no, employee_list -------------------------------- 10, A 10, A,B 10, A,B,C 10, A,B,C,D 20, A,B,C,D,P 20, A,B,C,D,P,Q 20, A,B,C,D,P,Q,R 20, A,B,C,D,P,Q,R,S

3 Answers  

---

HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?

4 Answers   L&T,

---

how to do pergformence tuning in datastage?

4 Answers   MCA, Symphony, TCS,

---

WHAT are unix quentios in datastage

2 Answers   TCS,

---

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

0 Answers   IBM,

---

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

0 Answers   IBM,

---

How can u write exception handling in seq file????

2 Answers   IBM,

---

What is container and then types?

1 Answers  

---

in datastage scenario this is sourec data i want this traget? tell me please? source target ------- ------- Mohan,Prasad,Naresh Mohan Prasad Naresh

1 Answers   IBM,

---

How many nodes supported by a one cpu in parallel jobs?

3 Answers   IBM,

---

What is the difference between passive stage and active stage?

0 Answers  

---

how many stages are there in Datastage... Please clarify mee??

3 Answers  

---