in star schema dimension and master data table are same.
in extend star schema dimension and master data table are 
different.( master data outside the cube and dim..table 
inside cube). in star schema we can analyis only 16 angle.
but in ex..star schema we can analyis 16*248 angle.

In starschema dimensions are not sharable where as in 
extended starschema dimension tables are sharable using SID
tables,i.e master data tables are out side the cube and 
every characteristic is connected to its corresponding 
master data table using surrogate id table.

In star schema dimension and master data table are same.
in extend star schema dimension and master data table are 
different.( master data outside the cube and dim..table 
inside cube). in star schema we can analyis only 16 angle.
but in ex..star schema we can analyis 16*248 angle.

Master data table uses SID, b'cuse to convert alpha numeric 
values to numeric this improves ur process speed.
And also we can analyze the angles in 16X248. 

By Gigs
BW Consultant, SAP German.

multi language support in extended star schema and also 
slowly changing dimensions also supported ,,but in star 
schema we dont have this option

In extended star schema Multi Languages is supported, 
tracking of history is possible, hierarchical structure is 
possible and master data is sharable.

in star schema master data tables are inside the cube.

demerit of star schema
limited analysis is possible since only 16 master data 
table can be accommodated in a cube.  

alpha nummerical values are getting posted in fact table 
that may degrade the perfomence.

master data table cant reuse for any other cubes. 

in ext. star schema

Surrogat id tables are genearated with the activation of  
master data table. based on sids dimention id will genarate 
and the dimention id will get posted in fact table.

so charactorstic value will not be there fact table insted 
did's and kf will be there.

master data table can be re used since its out side of the 
cube. 

3224 master data table can be used in fact table through 
dimention table.