Answer / venkatesh.m

we can't use round robin for aggrigator
Because round robin shares the records equally to all the
nodes.
but if it goes like that there may be a chance to get not
relevant o/p (UN expected o/p )

its better to use hash partition



if am wrong plz let me know

Answer / 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

Answer / chirag

can u plz explain this wit an example and if possible plz
mai me on chirag13189@gmail.com

how to handle null values in sequential file?

1 Answers   HCL,

---

how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?

1 Answers   Wipro,

---

how do u reduce warnings

1 Answers   CGI,

---

What a datastage macro?

0 Answers  

---

how to delete one row in target dataset

0 Answers   Satyam,

---

To see hidden files in LINIX?

0 Answers   CTS,

---

WHAT are unix quentios in datastage

2 Answers   TCS,

---

i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance

2 Answers   IBM,

---

What is the default execution order of the sequential file?

3 Answers  

---

ename like ibm,tcs,hcl need display those records only how?

2 Answers  

---

Wat is pre-load in Hashed file

1 Answers   Patni,

---

Highlight the main features of datastage?

0 Answers  

---