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
Go To First  |  Previous Question  |  Next Question 
 Abinitio  |  Question 11 of 192    Print  
Have you used rollup component? Describe how.

  
Total Answers and Comments: 3 Last Update: July 03, 2008   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
July 10, 2005 11:56:04   #1  
Ashim Dutta        

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. 

 
Is this answer useful? Yes | No
November 29, 2006 10:51:44   #2  
sangee        

RE: Have you used rollup component? Describe how.
rollup summarize the group of data records.for eg: if we want the maximum value of the cust_id we will go for rollup.
 
Is this answer useful? Yes | No
July 03, 2008 09:35:36   #3  
sixto.dsilva Member Since: March 2008   Contribution: 38    

RE: Have you used rollup component? Describe how.
Rollup summarises the group of data records based on key eg you want the income of a particular city from a set of records , you can use the rollup component.

example 
dml is customer ,city name and amount (here the key is city name)

1|NY|200.00|
2|NY|222.00|
3|CA|333.00|
4|CA|400.00|

here you can you the rollup component to sum the amount for a particular city , the output of rollup is shown below.

NY|422.00|
CA|733.00|

Hope this helps.

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape