Online Tutorials & Training Materials | STechies.com
Register Login

Difference between Extended Star Schema and Star Schema

|| 0

Difference between Extended Star Schema and Star Schema
Stechies

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