Search this blog

Saturday, June 19, 2010

BI: Dimensional Model - Star Schema

The star schema is the simplest style of data warehouse schema. The star schema consists of a few fact tables (possibly only one) referencing any number of dimension tables.





Star Schema Format 1:


Star Schema Format 2:


Star Schema Format 3:




















Star Schema Format 4:





1 comment: