Answer Posted / murali

By using CDC stage ..provide before and after datasets to CDC through CDC stage u get change code =3 then you can get updated records

Is the value of staging variable stored temporarily or permanently?

982

---

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

1359

---

How do you register plug-ins?

955

---

sed,awk,head

1446

---

Define Merge?

1298

---

Whats difference betweeen operational data stage (ods) and data warehouse?

1101

---

Name the different types of Lookups in Datastage?

1245

---

Differentiate between datastage and datastage tx?

1039

---

What is a folder? Difference types of stages?

1153

---

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

1023

---

Differentiate between hash file and sequential file?

1051

---

Enlist various types of routines in datastage.

1227

---

Different ways a project can be moved to production ?...example ….export-import and Version control.

2429

---

Explain how a source file is populated?

1349

---

What are the types of jobs we have in datastage?

1058

---