What is Molap and Rolap? What is Diff between Them?
Answer Posted / pratap gangula
Hi Marcelo,
The retrieval procedure is different because the storage model is different so ultimately the main difference between ROLAP and MOLAP is still in the storage concepts. While designing DW we dont decide whether the requirement is to fetch the data using SQL or MDX....rather we focus on whether the need for storing the data is in RDBMS format or Multidimensional format .
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How many types of facts and what are they?
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
What is the difference between metadata and data dictionary?
Explain how are the dimension tables designed?
What are the different types of fact tables used in data warehousing?
How to stop a batch?
What is degenerate dimension table?
What is meta data and system catalog?
Can you state some of the innovations throughout history?
What is fact less fact table? Where you have used it in your project?
What are the various tools? Explain name a few?
What is metadata in context of a datawarehouse and how it is important?
what are the others of "bad files" and "discard files" when using sql*loader?
Explain a relation schema and a relation?
Explain what does level of granularity of a fact table signify?