| |
GeekInterview.com > Interview Questions > Data Warehousing > Abinitio
| Print | |
Question: Have you used rollup component? Describe how.
|
| July 07, 2005 11:56:04 |
#1 |
| Ashim Dutta |
Member Since: Visitor Total Comments: N/A |
RE: Have you used rollup component? Describe how.
|
ashimdutta@yahoo.com
If the user wants to group the records on particular field values then rollup is best way to do that. Rollup is a multi-stage transform function and it contains the following mandatory functions.
1. initialise
2. rollup
3. finalise
Also need to declare one temporary variable if you want to get counts of a particular group.
For each of the group, first it does call the initialise function once, followed by rollup function calls for each of the records in the group and finally calls the finalise function once at the end of last rollup call.
|
| |
Back To Question | |
