Hi

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

Thanks&Regrds

jagan

Aggregate and rollup perform same action rollup display intermediat

result in main memory Aggregate does not support intermediat result.

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...

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

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...

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....

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

But Aggregate when processing ungrouped data it maximises the performance.