What is Molap and Rolap? What is Diff between Them?
Answer Posted / nethaji
MOLAP has aggregated value stored in cube.Since the data is
aggregated, query performance is fast.
ROLAP has data sored in relational databases.Here query has
to access the database for retrieving the data every time.So
performance is slow when compared to molap. Size is larger
than molap.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
How can we run the graph? What is the procedure for that?
Why should you put your data warehouse on a different system than your oltp system?
What is data cleaning? How can we do that?
What is real-time datawarehousing?
What is a Decision Tree Algorithm?
Explain the definition of normalized and denormalized view and what are the differences between them?
Explain the differences between normalizer and normalizer transformation?
What is the difference between data warehouse and operational systems?
What is the 4 + 1 view model as it relates to system modeling?
What is called data cleaning?
How to add a number to a macro variable?
Explain what are the basic needs to join two sources in a source qualifier?
What is execution plan?
what are the different views that are considered when building an object-oriented software system?