Answer Posted / vinod upputuri

Here is the Sample Scenario:
Max sal for each dept

I/P File: Dept
Deptno, Sal
10,21000
10,22000
20,23000
20,12000
30,41000

if you use the Round-robin for 2 node:

SEQ>>AGR>>Tar

no: 10,21000 n1: 10,22000 n2:20,23000
20,12000 30,41000

then the O/P: is all the records from all nodes. because in
no there is no matching deptno.

if you do the hash partition: then

no: 10,21000 n1:20,23000 30,41000
10,22000 20,12000

SO, the O/P: no:10,22000
n1:20,23000
n2:30,41000

What is the difference between server job and parallel jobs?

1134

---

On which Dimension Table you implemented SCD Type in your Project

2014

---

Is it possible to query a hash file?

1991

---

How and where you used hash file?

1153

---

What is the difference between odbc and drs stage?

1077

---

What is the difference between operational data stage (ods) and data warehouse?

1224

---

How to manage date conversion in Datastage?

1118

---

Explain the situation where you have applied SCD in your project?

2021

---

Does datastage support slowly changing dimensions ?

1096

---

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

2432

---

Differentiate between validated and Compiled in the Datastage?

1255

---

How do you import and export the datastage jobs?

1146

---

Which warehouse using in your datawarehouse

2174

---

Describe routines in datastage? Enlist various types of routines.

996

---

What is usage analysis in datastage?

1293

---