What's a Cube in Rolap?
- 2 Answers
- 10267 Views
- Oracle, I also Faced
- E-Mail Answers
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 |
What is the definition of cube in datawarehousing?
what is a hot file, why we need in datawarehousing, where we used in general
Explain what are non-additive facts?
Database in use is oracle?
What is application.cfm?
What is factless fact schema?
What are the other names given to data warehousing?
What is the main difference between inmon and kimball philosophies of data warehousing?
What are cursors?
Write a short note on data warehousing & three-Tier Warehouse architecture in detail.
What is Snow Flake Schema design in database?
What are steps we have to follow in designing the userfriendly universe?
Teradata 
