How is an Extended star schema of BW more advantageous than
the star schema?
Answer / 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|
What are the server related tuning?
How do you create event chains?
what is postprocessing, where we use this
What all data sources you have used to acquire data in sap bw system?
What are the two fact tables?
What are the data target administration tasks?
Explain table partition?
What is the scope of variables?
What is the SAP enhancement of data sources?
describe how you have used excel as a compliment to bex?
What are the extractor types?
What is an event chain?