Can we use Round Robin for aggregator?is there any benefit
underlying?
- 3 Answers
- 9036 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / venkatesh.m
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 |
Post New Answer View All Answers
What is the different type of jobs in datastage?
Triggers,VIEW,Procedures
How to read the length of word in unix?
Where do you see different stages in the designer?
What is oci?
What is the precedence of stage variables,derivations, and constraints?
What is the difference between hashfile and sequential file?
What is the difference between passive stage and active stage?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What are orabulk and bcp stages?
What is a merge?
What is staging variable?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
