What is the difference between OLAP, ROLAP, MOLAP and HOLAP?
Answer Posted / 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 |
Post New Answer View All Answers
What is the purpose of Dataware Control?
What is a real-time data warehouse?
Explain the definition of normalized and denormalized view and what are the differences between them?
What is surrogate key? Where we use it explain with example?
Why is dimensional normalization not required?
Explain what is partitioning? What are the types of partitioning?
Explain why denormalization is promoted in universe designing?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
In document how to create metrics?
What is the use of dimensional modeling in data warehousing?
What are the advantages of raid 1, 1/0, and
How to generate the cubes in framework manager?
Explain what is data validation strategies for data mart validation after loading process?
What are the mapping paramaters and maping variables?
Can you brief about the Data warehouse project you worked on?