Star Schema:
1. Master data is maintained inside the cube.
2. Dimention tables are specific to a fact table.extended star schema helps in multi language and multi hierarchy OLAP env
3. Schema in which fact table is in middle and surrounded by dimension tables
Extended Star Schema:
1. Master data is maintained out side of the cube.
2. Uses SID(Surrogate IDs) table so as to use same dimention table for all fact tables
3. Fact table is in middle and surrounded by dimension tables and the master data table is outside
.jpg)
.jpg)
