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 |
Tell me what is full load & incremental or refresh load?
What is prompt types of prompts?use of prompts syntax of prompt?
What is the capacity of power cube?
What is a view as it relates to system modeling?
Explain hybrid slowly changing dimension?
What is conformed fact?
What are diagrams?
0 Answers InfoAxon Technologies,
What are the different types of fact tables used in data warehousing?
What is the use of dimensional modeling in data warehousing?
can anybody mail me the FAQS for hyperion essbase amd planning
Who needs data warehousing?
what are different ways of loading data to data warehouse using oracle?