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 ?
RE: what is the use of aggregation when we have rollup...
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.
RE: what is the use of aggregation when we have rollup...
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?
RE: what is the use of aggregation when we have rollup...
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...
RE: what is the use of aggregation when we have rollup...
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.
RE: 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 ?
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
