Answer Posted / kalyanreddy

Hi Vijay,


first populate flatfile data to orale db

two methods,

1. write a join query in source oralce stage and link to
target.

2. take two oracle sources like s1 and s2 , use join stage
and link to target

or
direct method

3.take flat file and oracle source, use join stage and link
to target.

What is "fatal error/rdbms code 3996" error?

1248

---

What is datastage?

1068

---

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2023

---

What are stage variables?

1187

---

What are the different types of lookups in datastage?

1045

---

What is usage analysis in datastage?

1289

---

What is the roundrobin collector?

1081

---

What are routines in datastage?

1311

---

How do you start developing a datastage project?

1087

---

Differentiate between validated and Compiled in the Datastage?

1252

---

How and where you used hash file?

1148

---

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1357

---

What is a quality stage in datastage tool?

1061

---

How we can covert server job to a parallel job?

1119

---

Difference between sequential file and data set?

1185

---