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
what are the info cube developed in a sap project?name them and what is the requirement?
In real world when do you recommend aggregate?
List the steps to configure sd and mm for bw.
What is aggregate hierarchy?
What is an infoobject and why it is used in sap bi?
Is it possible for the users to convert the package group into a process chain? If so, how?
What are nodes?
List the steps to do the configuring third party (bapi) tools.
What is SAP exit?
Explain business blueprint stage.
What is business content?
What is the purpose of sap bw/bi?
What are the advantages of new LO extraction?
What are the delta options available when load from flat file?
What are the steps in general to enhance data?