Can we use Round Robin for aggregator?is there any benefit
underlying?
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 |
What is the use of Row generator stage?
How the ipc stage work?
Nls stands for what in datastage?
How rejected rows are managed in datastage?
what is the difference between INROWNUM AND OUTROWNUM IN DATASTAGE SERVER EDITION?
j1,j2,j3 jobs r runing iwant to run j1,j3 after j2 how to do this using sequencer? 2)j1,j2,j3 jobs r runing iwant to run j1,j2,j3 how to do this?
SOURCE CITY NAME1 NAME2 NAME3 NAME4 BGLR HCL CSC IBM TCS TARGET CITY COMPANY BGLR HCL BGLR CSC BGLR IBM BGLR TCS
You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?
what about data stage requirement
can any 1 put a difference between datastage 7.5 and 8.0 all concepts plz r mail 2 me anu4u09@gmail.com
Give an idea of system variables.
how to closeing records after 10,000 records come?