Answer Posted / rambabu

from sequential file connect copy stage
from capy take 2 o/p links and these o/p links conn to 2
transformer stages
next take funnel stage
in funnel set property funnel type=seq i thionk this is
solutions

What is aggtorec restructure operator?

1525

---

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2955

---

What is job control?

1195

---

What are the different types of lookups in datastage?

1107

---

What are the different layers in the information server architecture?

1173

---

Why we use surrogate key?

1304

---

Describe stream connector?

1359

---

What are stage variables, derivations and constants?

1282

---

What is the sortmerge collector?

1174

---

What are the features of datastage flow designer?

1099

---

What are the various kinds of containers available in datastage?

1100

---

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

1604

---

Define ds designer?

1327

---

What is the use of datastage designer?

1218

---

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2247

---