Interested to Buy Any Domain ? << Click Here >> for more details...
What is Molap and Rolap? What is Diff between Them?
- 10 Answers
- 20329 Views
- I also Faced
- E-Mail Answers
Answer Posted / suba
multidimensional online analytical processing and
relational online analytical processing. In MOLAP data is
stored in form of multidimensional cubes. The advantages of
this mode is that it provides excellent query performance
and the cubes are built for fast data retrieval. All
calculations are pre-generated when the cube is created and
can be easily applied while querying data.In ROLAP, the
data is stored in relational databases this model gives the
appearance of traditional OLAP’s slicing and dicing
functionality. The advantages of this model is it can
handle a large amount of data and can leverage all the
functionalities of the relational database.
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
How are the dimension tables designed?
Explain what does level of granularity of a fact table signify?
What is meant by metadata in context of a data warehouse and how it is important?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
How to create diff. Types of templates?
What needs to be done when the database is shutdown?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
Why should you put your data warehouse on a different system than your oltp system?
What is a core dimension?
Explain how many ways you create ports?
Explain what are the various transformation available?
What are session timeout and application timeout?
what are the major three types of modeling used?
What is Operational Data Store?
What is partitioning? What are the types of partitioning?
