GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Abinitio

 Print  |  
Question:  wat is the difference between rollup and scan?



December 12, 2006 04:05:55 #4
 mukund   Member Since: Visitor    Total Comments: N/A 

RE: wat is the difference between rollup and scan?
 

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

     

 

Back To Question