Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between OLAP, ROLAP, MOLAP and HOLAP?
- 2 Answers
- 43121 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 the main difference between inmon and kimball philosophies of data warehousing?
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?
What is mapplet?
What are the approaches used by optimizer during execution plan?
What are aggregate tables and aggregate fact tables?
Is it possible to have more than one row on the same table with the same foreign key?
Explain what is the difference between power center & power mart?
How can we run the graph? What is the procedure for that?
What are the types of partitioning?
Best Data Ware housing training institute in delhi
How to drill through from a powerplay cube to reportnet?
What is data stream and data adaopter. Is it same are different? Explain?
Teradata 
