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 is the maximum number of key figures you can have in an info cube?
What is SUMCT?
What is the use of CO-PA?
What is geographical information in the sap bw and for what purpose it is used commonly?
What is a cell editor?
What is the cell restriction and the options?
What is processing type customer exit?
What is extended star schema?
What are formula variables?
What is the scope of variables?
What are the differences between v1, v2, v3 jobs in extraction.
How we do the sd and mm configuration for bw?