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 ? | 2 Yes | 1 No |
Post New Answer View All Answers
How do you convert web objects from 2.x to 3.x?
when u creating infoobject it shows reference and template what is it
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
What is the function of bw statistics cube?
What is the process chain and how you used it?
What all data sources you have used to acquire data in sap bw system?
What is a SID table and advantages?
What exactly do you know about the term data flow in the business intelligence or business warehouse?
What is geographical information in the sap bw and for what purpose it is used commonly?
What is ?User master comparison? in roles?
wt is difference between user group and reference user group?
Can you explain about start routines how you used in your project give me an example?
Explain ods?
What is compression in the data warehouse?
Give an example of the content key figure OTOTALSTCK (quantity total stock)?