What is the difference between OLAP, ROLAP, MOLAP and HOLAP?
Answers were Sorted based on User's Feedback
ROLAP
ROLAP stands for Relational Online Analytical Process that
provides multidimensional analysis of data, stored in a
Relational database(RDBMS).
MOLAP
------
MOLAP(Multidimensional OLAP), provides the analysis of data
stored in a multi-dimensional data cube.
HOLAP
------
HOLAP(Hybrid OLAP) a combination of both ROLAP and MOLAP can
provide multidimensional analysis simultaneously of data
stored in a multidimensional database and in a relational
database(RDBMS).
DOLAP
-----
DOLAP(Desktop OLAP or Database OLAP)provide multidimensional
analysis locally in the client machine on the data collected
from relational or multidimensional database servers.
Is This Answer Correct ? | 69 Yes | 10 No |
Answer / guest
OLAP: Online analytical process. For analysis.
ROLAP: Relational Online analytical processing.
MOLAP: Multi dimensional analytical process.
HOLAP: Hybrid Online analytical process.
Is This Answer Correct ? | 41 Yes | 14 No |
What is the use of dimensional modeling in data warehousing?
I have two universes created by two difference database can we join them in designer & report level? How
What is informatica architecture?
Explain can a dimension table contains numeric values?
Can you pass sql queries in filter transformation?
For faster process, what we will do with the universe?
What are Data Marts?
What is confirmed dimension?
What is data stream and data adaopter?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
Explain what are components of report studio?
How many ways we test the universe & Report?