GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Abinitio

 Print  |  
Question:  what is the use of aggregation when we have rollup
as we know rollup component in abinitio is used to summirize group of data record. then where we will use aggregation ?





February 02, 2006 18:17:16 #5
 Mithun   Member Since: Visitor    Total Comments: N/A 

RE: what is the use of aggregation when we have rollup...
 

hi there

here is an Example. there are 2 groups in a company with 2 employees each with the following pay.

GROUP 1

    A.........10

    B..........20

Group 2

   C.........30

   D.........40

i cudnt think of any names....so bear with me.

Now a AGGREGATE component will produce a output of 100 (i.e 10+20+30+40)

and a ROLLUP will produce a output as

Group 1.......30

Group 2.......70.

i hope this explains you all. (i know its a bad example)

thanx

     

 

Back To Question