How is an Extended star schema of BW more advantageous than
the star schema?

Answer Posted / gireesh

1. star schema does not support hierarchy but extended star schema support hierarchy.
2. master data redundency in star schema and in extended star schema there is no masterdata redundancy.
3. In extended star schema master data devided in 3 categories that is
1. md text data
2. md attribute data
3. md hierachy data

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the info cube developed in a sap project?name them and what is the requirement?

2400


In real world when do you recommend aggregate?

1887


List the steps to configure sd and mm for bw.

504


What is aggregate hierarchy?

2520


What is an infoobject and why it is used in sap bi?

568






Is it possible for the users to convert the package group into a process chain? If so, how?

495


What are nodes?

1499


List the steps to do the configuring third party (bapi) tools.

440


What is SAP exit?

1647


Explain business blueprint stage.

532


What is business content?

1493


What is the purpose of sap bw/bi?

535


What are the advantages of new LO extraction?

1845


What are the delta options available when load from flat file?

552


What are the steps in general to enhance data?

1546