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 |
Explain what are non-additive facts?
Define data warehouse?
Explain can report net connect multiple datasource at a time in report creation time?
Explain in detail abt measure objects? And what is the use of it? How to create it?
what is user variable in affinium campaign? and some real time examples.
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
How can we transform row to column?
How to import vsam files from source to target. Do we need a special plugin?
Explain what is the metadata extension?
What are the types of dimensional modeling?
What are various warehousing tools?
Data WareHousing course in noida