What is Molap and Rolap? What is Diff between Them?
Answer Posted / suba
multidimensional online analytical processing and
relational online analytical processing. In MOLAP data is
stored in form of multidimensional cubes. The advantages of
this mode is that it provides excellent query performance
and the cubes are built for fast data retrieval. All
calculations are pre-generated when the cube is created and
can be easily applied while querying data.In ROLAP, the
data is stored in relational databases this model gives the
appearance of traditional OLAP’s slicing and dicing
functionality. The advantages of this model is it can
handle a large amount of data and can leverage all the
functionalities of the relational database.
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
Explain the versions of reportnet?
What are the types of SCD?
In document how to create metrics?
What are the other names given to data warehousing?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
Explain what are the various methods of getting incremental records or delta records from the source systems?
Explain the differences between normalizer and normalizer transformation?
Where the applications and where ware house management system is used?
Difference between e-r modeling and dimentional modeling?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
Explain the data types present in bo n wht happens if we implement view in the designer n report?
What are the stages that are required in data warehousing?
Which are the olap tools available that are supported by oracle?
Explain can a dimension table contains numeric values?