Interested to Buy Any Domain ? << Click Here >> for more details...
How is an Extended star schema of BW more advantageous than
the star schema?
- 1 Answers
- 2900 Views
- I also Faced
- E-Mail Answers
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
What is a dashboard in sap bw and how it is created?
How to fetch the data from sap-r/3, sap-bw/bi to informatica system? what is step by step procedure? at what senario you retrieve the data from sap system to informatica or say dwh system? --
What is the function of the ‘reconstruction’ tab in an info cube?
I have 80 queries which query is taking so much time how can you solve it
How to create condition and exceptions in bi.7.0?
Does it have delta facility?
What is an infopackage?
What are the advantages of new LO extraction?
What is the read mode in generic navigation block web item- read mode specifies
What are the hierarchy relevant parameters?
What are nodes?
What is the use of transformation and how the mapping is done in bw?
What is scoring ?
Explain the architecture of the sap bw system?
How do I send really complex mails from the workflow?
