| |
GeekInterview.com > Interview Questions > Data Warehousing > Abinitio
| Print | |
Question: wat is the difference between rollup and scan?
|
| April 04, 2008 05:21:47 |
#5 |
| sixto.dsilva |
CRM Expert Member Since: March 2008 Total Comments: 49 |
RE: wat is the difference between rollup and scan?
|
By using rollup we can generate aggregate values like sum ,count…..etc
here no of input records is not equal to output records.
where as by using scan we can generate cumulative
summaries of records. In rollup the finalize function is applied to a group of records where as in scan it is applied to every record. here no of input records is equal to output records.
you can use scan as a join also. |
| |
Back To Question | |
