What is Molap and Rolap? What is Diff between Them?
Answer Posted / pratap gangula
Hi Marcelo,
Your understanding of MDX execution flow is correct but
your interpretation of difference between ROLAP and MOLAP is
wrong. The difference between ROLAP and MOLAP lies in the way the data is stored which leads to two different data retrieval methodology.
OLAP storage models are designed basis how you want to store your data. I guess nobody would want to design the OLAP basis the data retrieval procedures.
You are simply challenging your own thought process.
Rgds,
Pratap
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
List down some of the real time data-warehousing tools?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
How to load the time dimension?
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?
Explain which are the olap tools available that are supported by oracle?
What are the differences between datamart vs. Reporting cube?
What is a general purpose scheduling tool?
What is the data type of the surrogate key?
How to provide security in frame work manager for a query subject?
How did you plan your Data ware house project?
What is Cognos script editor?
What is a real-time data warehouse?
Explain the difference between view and materialized view?
What are the stages of datawarehousing?
Explain what is the difference between powerplay transformer and power play reports?