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
In jump queries we can jump any transactions just like rsa1, sm37 etc it is possible or not?
How does bex analyzer connect to bw?
What are the steps to configure third party (BAPI)?
R/3 extraction failed - recovery procedure? R/3 extraction is running from past 2 years. Suddenly it failed since 5 days and again today it is running fine. But how i do get data loaded to cube for failed loads? What are the procedures that can be followed?
What is the licensing requirement you should be aware of?
How we do the sd and mm configuration for bw?
What is a temporal join?
What is infoobject otpauth?
What is the process chain and when you can use the same in the data warehouse?
You want to see the error idocs. Tell the navigation you would use.
What are the inputs for an infoset?
What is the difference between sending a mail to a recipient list compared to sending individual mails via a dynamic loop?
Are there any limitations for bex analyzer?
When you are using sap bi7.x, you can load the data to which component?
HOW CAN I APPLY PATCHES FOR BI 7.0 WITHOUT USER ID AND PASSWORD OF SAP?