what is difference between star schema and extend star
schema?

Answer Posted / dhalpathi

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.

Is This Answer Correct ?    93 Yes 14 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How are dimensions optimized?

1491


What are the steps to create classes?

1630


What is translation key?

1566


Explain return tables.

521


is there is any book that covers all topics of BI 7.0 and the navigation steps for bi 7.0 and pdf of 7

1502






What is transfer routines.

532


What is occurence

1777


What are the settings for data transfer?

1497


What are the components of sap bw system?

494


my intermediate is mpc and my graduation is bcom and pg is mba. learnt sap bw and abap. tell me the interview questions for the same?

1696


Give an example of VBA?

1352


I have cube.for cube data coming from 3dso's.in one dso having special chars.in cube you got special char error.how u can resolve this?

1392


What is partition of an infocube?

536


When you fill in the values for selection, what are the options available in general?

1606


Explain the display properties?

1719