What's a Cube in Rolap?

Answers were Sorted based on User's Feedback



What's a Cube in Rolap?..

Answer / swati

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 ?    5 Yes 0 No

What's a Cube in Rolap?..

Answer / fatma

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 ?    4 Yes 1 No

Post New Answer

More Data Warehouse General Interview Questions

Hi,Please can u tell me.. What is the difference between a Hyperion Essbase CUBE and a Star Schema? Thanks in advance, Vijay.

1 Answers   iFlex, Wipro,


Store (and count) non-fact records?

0 Answers  


What are necessary tasks to install reportnet software?

0 Answers  


What is index awareness in universe?

0 Answers  


where exactly in dataware house a confirmed dimension can be created

4 Answers   Deloitte,






What is load manager?

0 Answers  


What are the different types of join operations?

0 Answers  


List any five applications of data warehouse.

0 Answers  


What is analytical or analytic mean?

0 Answers  


Explain piconet?

0 Answers  


Explain can a dimension table contains numeric values?

0 Answers  


Explain what is partitioning? What are the types of partitioning?

0 Answers  


Categories