BRIAN CIAMPA
Enabling excellent decision making through data warehousing and business intelligence

Advanced Concepts

This is a more advanced example of a star schema. In this case, the star schema contains a dimension table that is joined to another dimension table instead of being joined directly to the fact (see the DIM_EXECUTIVE_INFORMATION table). Click on a table to read about the role that that table plays in this type of design.