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 capture rejected data by using join stage not for lookup stage. please let me know

3 Answers   Satyam,

---

How do you remove duplicate values in datastage?

0 Answers  

---

What are the areas of application?

0 Answers  

---

What is the difference between SQl Loader and OCI in datastage?

2 Answers   CSC,

---

i want for the 3rd max sal using for the any stage but max sal is based on the deptno ? any body know this ans pls send this mail siva3me@gmail.com

2 Answers   Wipro,

---

What is the difference between server job and parallel jobs?

0 Answers  

---

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

0 Answers  

---

cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle

3 Answers   TCS,

---

How do u call shellscript/Batch file from DS?

4 Answers   HP,

---

Define Routines and their types?

0 Answers  

---

i have the source from Uk,north america how can i pass the data two tables based on the locations

2 Answers  

---

How do you import and export the datastage jobs?

0 Answers  

---