Can we use Round Robin for aggregator?is there any benefit
underlying?
- 3 Answers
- 9035 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?
How many types of hash files are there?
What are the processing stages?
what is the difference between INROWNUM AND OUTROWNUM IN DATASTAGE SERVER EDITION?
how do u convert date in 20-12-07 to dec-20-2007 or 20-dec- 2007 or 20-dec-07 in parallel
what is snow flack schema?
what are the types of nodes
can explain wt is the pool for file.
What r the existing server jobs in parallalism?
What are the important features of datastage?
Teradata 
