Iin Classic star schema, dimension and master data table are same. But in Extend star schema, dimension and master data table are different. (Master data resides outside the Infocube and dimension table, inside Infocubecube).
In Classic star schema we can analyze only 16 angles (perspectives) whereas in extended star schema we can analyze in 16*248 angles. Plus the performance is faster to that extent.
Below are some of the basic differences between the two.
Classic Star Schema |
BW Star Schema |
|---|---|
Fact |
Key Figure |
Dimension Attribute |
Characteristic |
Described Attribute |
Attribute |
- |
External Hierarchies |
Dimension Tables |
Dimension Tables |
Dimension = Dimension Table |
Dimension = |
Manoj