Can we use Round Robin for aggregator?is there any benefit
underlying?
- 3 Answers
- 9038 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / vinod upputuri
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 |
Post New Answer View All Answers
What are the features of datastage flow designer?
Why we use surrogate key?
How many types of sorting methods are available in datastage?
What are data elements?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
How complex jobs are implemented in datstage to improve performance?
Have you have ever worked in unix environment and why it is useful in datastage?
Can you highlight the main features of ibm infosphere information server?
Where do the datastage jobs get stored?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
how to export or import the jobs in .ISX file
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
What are the steps needed to create a simple basic datastage job?
What are the types of jobs we have in datastage?
table actions available in oracle connector?
