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 to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

0 Answers   HCL,

---

What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?

1 Answers  

---

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

0 Answers  

---

Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?

3 Answers   IBM, TCS,

---

What is exact difference between Parallel Jobs and server Jobs..

8 Answers   DELL, IBM,

---

What are the various kinds of the hash file?

0 Answers  

---

What are the different kinds of views available in a datastage director?

0 Answers  

---

On which interface you will be working as a developer?

0 Answers  

---

what is the use of materialized view?

0 Answers   CTS,

---

What are the different type of jobs in datastage?

0 Answers  

---

Please tell me What is difference between 8.0 and 8.1

1 Answers   IBM,

---