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
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
What is the main difference between schema in rdbms and schemas in datawarehouse?
How can you implement many relations in star schema model?
What are the stages of datawarehousing?
What are the data marts?
What is defined as partial backup?
What is called dimensional modelling?
Why is dimensional normalization not required?
Explain Association algorithm in Data mining?
What is load manager?
Can we take backup when the database is opened?
What is data analysis? Where it will be used?
Explain dimensional modelling?
What is the function of etl when used in data warehousing?