Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use Round Robin for aggregator?is there any benefit
underlying?
- 3 Answers
- 9996 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 |
How to display all the duplicate records from the oracle Table?
Why we use surrogate key?
4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 please send me answer this question my mail
What is the difference b/w Hash file and Lookup Fileset stages?
how to sort two columns in single job in datastage.
State the difference between an operational datastage and a data warehouse?
my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage
How do you remove duplicate values in datastage?
What is quality stage?
What are routines in datastage? Enlist various types of routines.
Explain how a source file is populated?
what is the difference between datasatge and datastage TX?
Teradata 
