Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between OLAP, ROLAP, MOLAP and HOLAP?
- 2 Answers
- 43306 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 |
Can we take backup when the database is opened?
WHAT IS FACT LESS FACT TABLE?
What is informatica architecture?
What is the differences between star and snowflake schemas?
Explain what are slowly changing dimensions?
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
What is factless fact tables?
wht is degenerated dimension ?it's uses?
What are loops in Datawarehousing?
Teradata 
