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 are session timeout and application timeout? Where we have to do this process?
what are different storage options supported by oracle ?
What do you mean by static and local variable?
hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit
Do you view contain data?
What is type 2 version dimension?
What are the data types present in bo? What happens if we implement view in the designer n report?
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
What is pre-emptive and non-pre-emptive?
What are the differences between star and snowflake schema?
What are the different types of fact tables used in data warehousing?
Why we use repository connectivity?
What is a data profile?
Tell me what is full load & incremental or refresh load?
Explain what are non-additive facts in detail?