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

Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?

2122

---

What is difference macros and prompts?

2312

---

What is dimensional modelling?

991

---

What are the fundamental elements of the data warehouse?

1003

---

What are components of reportnet?

1079

---

Explain what are the advantages data mining over traditional approaches?

1166

---

Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?

926

---

Explain the process of extracting data from source systems,storing in ods and how data modeling is done?

933

---

Define data warehouse?

1048

---

What is conformed fact?

1102

---

What is a cube in data warehousing concept?

1082

---

Explain what are the different types of join operations?

973

---

What is a real-time data warehouse? How is it different from near to real-time data warehouse?

965

---

What is the difference between mapping parameter & mapping variable in data warehousing?

993

---

Explain what are the possible data marts in retail sales?

1015

---