ORACLE BUSINESS INTELLIGENCE II

The implementation is based on star schema model in the first figure. As you see, dimension tables are directly connected to fact table. So when a result set is needed dimension fact tables will be both accessed.

The other option is called Snowflake Schema Model. You can see this model in the following figure. Actually this model is a extension of star schema model. There are some dimension tables that are not joined directly to fact table