Answer Posted / 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 View All Answers
Explain er diagram?
Compare and contrast aggregates & indexes
Database in use is oracle?
What are the differences between star and snowflake schema?
What are the types of dimensional modeling?
What is the difference between static cache and dynamic cache?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
Why is chameleon method used in data warehouse?
What is index awareness in universe?
What is the working process for application.cfm?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
Explain how are the dimension tables designed?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
Explain the difference between keylokup and joiner?
What is the use of tabular model, tabular sql, tabular reference in real time application?