Can we use Round Robin for aggregator?is there any benefit
underlying?
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
Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
What is oci?
Can you explain how could anyone drop the index before loading the data in target in datastage?
How a source file is populated?
Different ways a project can be moved to production ?...example ….export-import and Version control.
how to write server Routine coding?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
Describe stream connector?
What are the types of containers?
Explain the importance of surrogate key in data warehousing?
What is the differentiate between data file and descriptor file?
Highlight the main features of datastage?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
what is the difference between == and eq in UNIX shell scripting?
What are the steps needed to create a simple basic datastage job?
How and where you used hash file?