Answer Posted / marcelo malheiros

I know a lot of people understand ROLAP and MOLAP as where
the information is stored: if data is in a RDBMS, is ROLAP;
if it is in a self-contained cube, it is MOLAP.

What I find the above a misconcept of the terms.

I believe ROLAP and MOLAP differs from each other in the
language you use to retrieve the result set and the result
set format...

I don't find that storage is relevant... How would classify
BI done on top of IMS, IDMS, ADABAS, VSAM and other non
RDBMS data storages?... Yes, BI started using those data
repositories... As well, how would you classify BI deployed
on top of a flat file or an XML file?...

SO MY POINT IS THAT THE DATA STORAGE DOES NOT DEFINE ROLAP
OR MOLAP...

By MOLAP:
I understand that the data is retrieved via MDX and the
result set is formated as a hiearchy with tags (something
similar to XML) which provides seemless hierarchy
manipulation capabilities to MOLAP.

By ROLAP:
I understand that the data is retrieved via SQL (relational
algebra) and the result set is always formatted as a table.

My humble 2 cents...

Cheers!
Marcelo

Explain which are the olap tools available that are supported by oracle?

1047

---

What is the difference between dependent data warehouse and independent data warehouse?

1054

---

What is edw?

1268

---

Explain what are the mapping paramaters and maping variables?

1136

---

Explain what are the various methods of getting incremental records or delta records from the source systems?

1029

---

How do you create surrogate key using ab initio?

1048

---

What is critical column?

1258

---

Explain the difference between filter and conditin?

1014

---

In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?

2300

---

What are the differences between datamart vs. Reporting cube?

1158

---

What are the differences between star and snowflake schema?

1176

---

Can decision tree be implemented using SQL?

2169

---

Explain about core dimension,

1036

---

What is a relationship?

1036

---

Explain vldb?

1079

---