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
Explain degenerate dimension table?
Explain difference between e-r modeling and dimentional modeling?
Explain what is the metadata extension?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
What are diagrams?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
What is load manager?
Explain what is the extension of file to save template?
What is the function of surrogate key in data warehousing?
Explain vldb?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
Explain if a flat file cotains 1000 records how can I get first and last records only?
What is the difference between filter and lookup transformation?
explain about dirty dimension?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.