What is Molap and Rolap? What is Diff between Them?
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
Explain bus schema?
What is called data cleaning?
How can we load the time dimension?
What is cubes?
Explain differences between star and snowflake schemas?
What is Sequence clustering algorithm?
Explain what is fact less fact table? Where you have used it in your project?
Explain which columns go to the fact table and which columns go the dimension table?
Explain what are the tasks that loadmanger process will do?
Can any one explain about core dimension, balanced dimension, and dirty dimension?
What are cluster analysis in data warehousing?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
What are the reasons to use a chameleon method in data warehousing?
What are the difference between snow flake and star schema?
What is data warehouse architecture?