Can we use Round Robin for aggregator?is there any benefit
underlying?

Answers were Sorted based on User's Feedback



Can we use Round Robin for aggregator?is there any benefit underlying?..

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

Is This Answer Correct ?    16 Yes 0 No

Can we use Round Robin for aggregator?is there any benefit underlying?..

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

Is This Answer Correct ?    10 Yes 2 No

Can we use Round Robin for aggregator?is there any benefit underlying?..

Answer / chirag

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

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Stage Interview Questions

what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none

1 Answers   Wipro,


How to reverse the string using SQL?

0 Answers   CTS,


how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

0 Answers   HCL,


What is the differentiate between data file and descriptor file?

0 Answers  


A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.

3 Answers   IBM,






Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/

4 Answers   TCS,


What are the unit test cases you used in your project?

1 Answers   CSC, HY,


WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

0 Answers  


INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?

11 Answers   CTS,


What is exact difference between Parallel Jobs and server Jobs..

8 Answers   DELL, IBM,


What's the Main Function of the Staging area in DWH

3 Answers   Oracle,


in datastage scenario this is sourec data i want this traget? tell me please? source target ------- ------- Mohan,Prasad,Naresh Mohan Prasad Naresh

1 Answers   IBM,


Categories