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 the data types present in bo n wht happens if we implement view in the designer n report?
Explain clustering algorithm?
What are the steps involved in creating dimensional modeling process?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
what are relationships?
Explain a mapping, session, worklet, workflow, mapplet?
Explain the definition of normalized and denormalized view and what are the differences between them?
How are models actually derived?
What are Non-additive facts?
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
What is edw?
How to create prompts in report net?
Explain what are the various methods of getting incremental records or delta records from the source systems?
What are data modeling and data mining? Where it will be used?
How to create different types of templates?