Answer Posted / dilip anand k.

Nope. Dataset can never be used as a primary source or a
final target. It can be used only as an intermediate storage
or intermediate source and a target. This is because,
Dataset is something that is proprietary to Data stage and
is understandable only to Data stage engine and none other.

What are routines in datastage? Enlist various types of routines.

1152

---

root tree will find which is server job and which is parallel job?

2036

---

What is the different type of jobs in datastage?

1024

---

Difference between data warehousing and olap?

1140

---

Can you explain players in datastage?

1245

---

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2323

---

Explain usage analysis in datastage?

1222

---

What are orabulk and bcp stages?

1163

---

Explain the importance of surrogate key in data warehousing?

1231

---

What is quality stage?

1042

---

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

2870

---

How do you generate sequence number in datastage?

1139

---

How to read multiple files using a single datastage job if files have the same metadata?

1299

---

Differentiate between validated and Compiled in the Datastage?

1353

---

What is the difference between server job and parallel jobs?

1198

---