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
Explain reference cursor?
How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?
Explain why are oltp database designs not generally a good idea for a data warehouse?
Where the applications and where
How can we determine what records to extract?
Can you state some of the innovations throughout history?
How do we design a universe?
Why denormalization is promoted in universe designing?
What is data analysis?
What is surrogate key? Explain with examples.
Explain a linked cube?
Where the data cube technology is used?
What is the extension of file to save template?
How to generate iqd file from framework manager?
What is the advantages data mining over traditional approaches?