Child pages
  • Basic differences between Classic and Extended Star Schema
Skip to end of metadata
Go to start of metadata

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
 Text

               -

External Hierarchies

Dimension Tables
 (Contain Master Data)

Dimension Tables
 (do not contain Master data

Dimension = Dimension Table

Dimension =
 Dimension Table (optional),
 SID Tables,
 Master Data Tables (optional)



Manoj