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 will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none
How to reverse the string using SQL?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What is the differentiate between data file and descriptor file?
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.
Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/
What are the unit test cases you used in your project?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
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?
What is exact difference between Parallel Jobs and server Jobs..
What's the Main Function of the Staging area in DWH
in datastage scenario this is sourec data i want this traget? tell me please? source target ------- ------- Mohan,Prasad,Naresh Mohan Prasad Naresh