What is Molap and Rolap? What is Diff between Them?
Answer Posted / pratap gangula
In addition to the above answers, ROLAP storage models are better and faster for real time reporting & analytics whereas MOLAP storage models takes time to update itself. ROLAP models are slower because every query fired on cube has to satisfy RDBMS policies as well.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Why facts table is useful in representing the data?
What is Active Datawarehousing?
What is the metadata extension?
How do you define data block size?
What is the limit to the number of sources and targets you can have in a mapping?
How to create context?
Compare and contrast aggregates & indexes
Explain what are the various transformation available?
What is the main difference between inmon and kimball philosophies of data warehousing?
Explain the definition of normalized and denormalized view?
What is the difference between power center and power mart?
How to add a number to a macro variable?
How many types of facts and what are they?
What is latest version of power center / power mart?
Why is business intelligence (bi) important in data warehousing?