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

when u face critical situation in ur project, how to solve them?

1 Answers   Toyota,

Describe routines in datastage? Enlist various types of routines.

0 Answers  

what is the difference between the join and look up explin me one exmple

3 Answers  

I want capture UnMatched records from Primary source and secondary source in JOIN stage?

3 Answers   TCS,

how can u find out the datastage job is running on how many nodes

7 Answers   IBM,

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

1 Answers  

What are stage variables, derivations and constants?

0 Answers  

Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?

3 Answers   TCS,

iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..

4 Answers   Wipro,

Define APT_CONFIG in Datastage?

0 Answers  

How will you move hashed file from one location to another location?

0 Answers   NTT Data,

how to run a sequential file stage in parallel if the stage is used on the TARGET side

0 Answers   Virtusa,

For more Data Stage Interview Questions Click Here
Categories