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 ?

Questions by Beena   answers by Beena

Showing Answers 1 - 16 of 16 Answers

Ashim Dutta

  • Oct 20th, 2005

Aggregation and Rollup both can summerise the data but rollup is much more convenient to use. In order to understand how a particular summerisation being rollup is much more explanatory compared to aggregate. Rollup can do some other functionalities like input and output filtering of records.

  Was this answer useful?  Yes


  • Nov 24th, 2005


  This is jagan, I have one doubt what is diff between agreegate and rollup component.



  Was this answer useful?  Yes


  • Nov 29th, 2005

Aggregate and rollup perform same action, rollup display intermediat

result in main memory, Aggregate does not support intermediat result.

  Was this answer useful?  Yes


  • Jan 16th, 2006


Rollup never produce intermediate results,for intermediate results we have to use Scan component.

The difference between Aggregator & rollup is

rollu is extended version of aggregator,rollup having built-in summry functions like sum,count,avg,min,max,product...


  • Feb 8th, 2006

hi there

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




Group 2



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)



  • Mar 16th, 2006

Rollup is the enhanced and upgraded version of aggregrate. Aggregrate was the older version and rollup is the new version, as clear as it says. Abinitio reccommends to use rollup instead of aggregrate. Functionally there is no difference between the two. Why you guys don't refer to the help file?

  Was this answer useful?  Yes


  • May 7th, 2006

as i was going to through this thread, i see people saying a couple of things which give good info and one of the post says "Rollup never produce intermediate results, and for intermediate results we have to use Scan component."

as i see in the help as

Aggregate: Generates summary records for groups of input records.  It maximizes performance by keeping intermediate results in main memory.

Rollup: Generates data records that summarize groups of data records.  Rollup in Memory maximizes performance by keeping intermediate results in main memory.

so i feel the above post contradicts the help..... which says "maximizes performance by keeping intermediate results in main memory" for both components

Plz do let me know if i was wrong anywhere i am still learning Ab Initio...

  Was this answer useful?  Yes

I would like to add a point on usage of rollup over aggregate:

Rollup has a good control over record selection, grouping and aggregation as compared to that of aggregate.Rollup is an updated version of aggregate.Better go for roolup ovre Aggregate.

For more details see in the help doc..

Hope this clears your doubt..

Siva Krishna....

  Was this answer useful?  Yes


  • Nov 20th, 2007

Rollup  gives you more control over record selection, grouping, and aggregation than aggregate.

But Aggregate ,when processing ungrouped data it maximises the performance.

  Was this answer useful?  Yes


  • Dec 10th, 2007

aggreate n rollup will perform the same task i.e it summarises the group of records into a single summary record...But where as in rollup we can use aggregator functions such as AVG, SUM, MAX, MIN, COUNT which cant be used in aggregator component

  Was this answer useful?  Yes


  • Dec 18th, 2009

Rollup gives more control over the handling of records than aggregate comp. We cannot do the transformations which we can do with rollup expanded mode.

  Was this answer useful?  Yes


  • Sep 26th, 2010

Rollup is multistage component. It is working as a text mode and package mode.
In package mode user has to  develop own logic. In text mode it work as a aggregate component.
It is one type of facility in roll up.

  Was this answer useful?  Yes


  • Nov 20th, 2018

I am yet to work on Ab Initio. What I see from this thread is no one knows, the exact differences between the Roll Up and Aggregate apart from the Performance. Every transform will have its own capability. Performance depends on the volume of data and the logic we use. I will try to put a graph and will try all the options.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions