guys,
Rollup:
1)generally rollup is used for aggregation purposes such as sum,avg,count,min,max etc.
2)It can process grouped or ungrouped records.while processing ungrouped records it maximises the performance by keeping the intermediate results in main memory
3)It has more control over record selection,grouping and aggregation than aggregate component.
4)it is a multistage component
Scan:
1)scan is used to produce cumulative summary of records such as year-to-date totals for groups of input records
2)it is a multistage component
A multistage component is a componet which transforms the input records in 5 levels,such as input selection,temporary initialization,processing ,output selection,and finalize.for each level it is treated as a transform and a dml is written for each stage.
hey ,not but the least we can have "SCAN WITH ROLLUP" component to cater the needs of both scan and rollup.
yuppy,
Mukund