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

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 ?

January 01, 2006 07:29:47	#4
Shashidhar	Member Since: Visitor Total Comments: N/A
RE: what is the use of aggregation when we have rollup...
Hi, 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...

Back To Question