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

what is a nodemap constraint

2 Answers   IBM,

---

What are stage variables and constants?

0 Answers  

---

what is use of SDR function?

0 Answers   CGI,

---

How to create environments and call them? What is the use defined variables?

2 Answers   HCL, ME,

---

What are the various kinds of the hash file?

0 Answers  

---

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

0 Answers  

---

What modeling tool do you use?

6 Answers   HP,

---

What are the various kinds of containers available in datastage?

0 Answers  

---

insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 100 records target?

5 Answers  

---

I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????

5 Answers  

---

How can u write exception handling in seq file????

2 Answers   IBM,

---

What is the Difference Between DataStage 7.5 version and 8.1 Version?

10 Answers   IBM,

---