ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Data Warehouse General
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question
What's a Cube in Rolap?
 Question Submitted By :: Wed Elmahdi
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What's a Cube in Rolap?
Answer
# 1
ROLAP Cube is a datastructure that is used for faster analysis of data.ROLAP is slow at analysis but large at capacity(Multibillion rows can b stored) u can use good indexes to improve its performance
 
Is This Answer Correct ?    1 Yes 0 No
Swati
 
  Re: What's a Cube in Rolap?
Answer
# 2
ROLAP Cubes: stands for Relational OLAP. In ROLAP cubes a 
copy of data from the fact table is not made and the data 
aggregates are stored in tables in the source relational 
database. A ROLAP cube is best when there is limited space 
on the Analysis Server and query performance is not very 
important. ROLAP local cubes contain the dimensions and 
cube definitions but aggregates are calculated when they 
are needed. ROLAP cubes require less storage space than 
MOLAP and HOLAP cubes.
 
Is This Answer Correct ?    0 Yes 0 No
Fatma
 
 
 

 
 
 
Other Data Warehouse General Interview Questions
 
  Question Asked @ Answers
 
What is ?Data mining??  2
three ways sql*loader could load data, what are those three types?  1
What is mapplet?  1
What is Molap and Rolap? What is Diff between Them?  9
capital of tamilnadu Wipro1
How can we do ETL process in SQL Server? ETL1
What is an OLTP (Online Transaction Processing) System?  3
5.Explain ODS ? HCL3
What is IQD file?  1
What is DTS ?  1
wht is degenerated dimension ?it's uses? CTS8
suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ? Oracle3
what is data validation strategies for data mart validation after loading process  1
which automation tool is used in data warehouse testing?  1
What is ?Data Warehousing??  2
in siebel analytics by using dashboard prompts in a page have 2 reports so i have to give dashboard prompt to applied on first report only that will not applied to 2 report how it will do IBM1
What is confirmed dimension?  5
What is aggregate awareness?  2
what is query optimizer? what are different types of optimizer s supported by oracle ? ABC1
Where can one get more info about Data Warehousing? TCS2
 
For more Data Warehouse General Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com