Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between OLAP, ROLAP, MOLAP and HOLAP?
- 2 Answers
- 43296 Views
- I also Faced
- E-Mail Answers
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 |
Explain what are the various methods of getting incremental records or delta records from the source systems?
What is an error log table in informatica occurs and how to maintain it in mapping?
what is table partitioning? How it is useful to warehouse database?
What is VLDB?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
What is a cube in data warehousing concept?
In microstrategy, how can we direct the sql generated to use a specifc table?
Give me a broad concept of what a data warehouse is, and what it might be used for?
What is a functional dependency f said to be minimal?
what are different ways of loading data to data warehouse using oracle?
What is a data profile?
What is mean by aggregate aware?
Teradata 
