Answer Posted / sri

Using the Pivot we can convert the columns into rows

Nls stands for what in datastage?

1187

---

how to add a new records into source?

1996

---

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.

2892

---

What are the functionalities of link collector?

1083

---

how to write server Routine coding?

2116

---

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2470

---

What is the purpose of pivot stage and types of containers in datastage

1033

---

What is orabulk stage?

1045

---

Can you filter data in hashed file?

3772

---

Define Job control?

1138

---

What is difference between symmetric multiprocessing and massive parallel processing?

1134

---

Differentiate between Join, Merge and Lookup stage?

1090

---

Explain usage analysis in datastage?

1158

---

Differentiate between data file and descriptor file?

1049

---

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

3117

---