Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

Can we use Round Robin for aggregator?is there any benefit
underlying?

Question Posted / guru

Answers were Sorted based on User's Feedback



Can we use Round Robin for aggregator?is there any benefit underlying?..

Answer / 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

Can we use Round Robin for aggregator?is there any benefit underlying?..

Answer / 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

Can we use Round Robin for aggregator?is there any benefit underlying?..

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

Post New Answer

More Data Stage Interview Questions

I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?

6 Answers   Cap Gemini,

If you want to use the same piece of code in different jobs, how will you achieve it?

0 Answers  

What all the types of jobs you developed?

0 Answers  

What is staging variable?

0 Answers  

Hi guys, 7. how to get this output i/p col1,col2 101,a 102,b 103,c 104,d o/p col1,col2 101,d 102,c 103,b 104,a Thanks

2 Answers   Cap Gemini, IBM,

what is the difference between 7.1,7.5.2,8.1 versions in datastage?

3 Answers   IBM,

how will u design file watch jobs?

2 Answers  

WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?

2 Answers   Wipro,

WHAT IS FORCE COMPILE?

3 Answers   FIS, HCL, Polaris,

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

5 Answers   IBM,

when will you go for dataset and fileset?

2 Answers   Accenture,

i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?

1 Answers  

For more Data Stage Interview Questions Click Here
Categories