Have you used rollup component? Describe how?
Submitted by: AdministratorIf 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online Ab Initio Job Interview Questions And Answers
Top Ab Initio Questions
☺ | How do you convert 4-way MFS to 8-way mfs? |
☺ | What is skew and skew measurement? |
☺ | What is local and formal parameter? |
☺ | What is the difference between rollup and scan? |
☺ | What does dependency analysis mean in Ab Initio? |
Top Data Warehouse Job Categories
☺ | Warehouse Assistant Interview Questions. |
☺ | Ab Initio Interview Questions. |
☺ | Data Stage Interview Questions. |
☺ | ColdFusion Interview Questions. |
☺ | Data Warehouse Supervisor Interview Questions. |