Database Software

Surest i´m in a mistake but i want to tell you...
I think that if i want to build a data warehouse i have two options in ORACLE.

1. MOLAP data warehouse.
So i have to create an analytic workspace and define there logic objects like dimensions, hierarchies, levels, and so on. Later i map data from OLTP systems to the logic objects ... (here i have a question)

* The OLTP data must be in a star or snowflake scheme?
* The ETL stage is made on OLTP or in analytic workspace?

... and later i execute calculates over the logic objects form a OLAP application ... (here i have another question).

* I can make this calculates with OLAP DML or just with SQL???

2. ROLAP data warehouse. Here i just create tables (facts and dimensions) in a star o snowflake scheme, load data from OLTP systems on this tables and
later i consult them using pure SQL.

Someone from this respectable forum can tell me if i'm in a mistake. I appreciate your help.

Thanks a lot.


Lisandro A.
Oracle User
University of Cauca
Colombia - South America