What's a Cube in Rolap?
Answers were Sorted based on User's Feedback
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 |
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 |
Database in use is oracle?
Can a dimension table contain numeric values?
What is the difference between drill through and masterdetail reports?
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
The same tier?
what is query optimizer? what are different types of optimizer s supported by oracle ?
Is it possible to have more than one row on the same table with the same foreign key?
What is pre-emptive and non-pre-emptive?
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
What is BCP?
How to drill through from a powerplay cube to reportnet?
Explain can a dimension table contains numeric values?