What is the difference between OLAP, ROLAP, MOLAP and HOLAP?
- 2 Answers
- 42307 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 data marts?
What is aggregate fact table?
Explain how many ways you create ports?
Can you brief about the Data warehouse project you worked on?
What is latest version of power center / power mart?
What is XMLA ?
I know of using applysimple, but there are other ways too?
how to calculate sum(sal) with out using aggregator satge
What are algorithms provided by Microsoft in SQL Server?
What are the other names given to data warehousing?
3.What is fact less fact ?
9 Answers Accenture, HCL, TCS,
Explain swot analysis?
Teradata 
