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

Can you explain engine tier in information server?

1185

---

What are the types of containers?

1310

---

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2115

---

What are stage variables and constants?

1193

---

Why do we use link partitioner and link collector in datastage?

1187

---

Triggers,VIEW,Procedures

1265

---

how to abort the job its matain duplicates?

2623

---

How can we improve performance of data stage jobs?

1067

---

What is the difference between the local container and shared container?

1144

---

What are the types of hashed files in data stage

1146

---

Can we use target hash file as a lookup ?

3372

---

How to Remove Duplicate using SQL?

1424

---

On which Dimension Table you implemented SCD Type in your Project

2113

---

How do you start developing a datastage project?

1160

---

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

1154

---