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

How rejected rows are managed in datastage?

1443

---

Why fact table is in normal form?

1147

---

What are sequencers?

1055

---

What are stage variables and constants?

1095

---

Explain the importance of surrogate key in data warehousing?

1126

---

Can you filter data in hashed file?

3720

---

What is the process of killing a job in datastage?

961

---

What is difference between join, merge and lookup stage?

1035

---

What is the difference between in process and inter process?

1089

---

Name the different types of Lookups in Datastage?

1213

---

What are the difference types of stages?

1132

---

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

2385

---

What are the main differences you have observed between 7.x and 8.x version of datastage?

1022

---

how can we create rank using datastage?what is the meaning of rank?

8705

---

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2196

---