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 ? | 1 Yes | 1 No |
Post New Answer View All Answers
Explain 0record mode?
What is the number of decimal places in scaling factor?
When you define aggregates, what are the available options?
describe how you have used excel as a compliment to bex?
Why is one request falls, all the subsequent requests are turned to ?red? in an info provider?
how to getweekday,weekmonth,month,weekno,week order in the report by using routines?
What is ?predefined characteristics??
What is the attributes only flag?
what is a multiprovider? what are the uses and in which case supposed to be use? difference between bi7.0/bw3.5?
What are the system tools you can use?
In update rules for an infocube we can specify separate update rules for characteristics of each of the key figures. In which situations is the above used?
What are value sets?
You have 10 cubes for which you created multiprovider but you want data only for one cube. What will you do?
What are the steps to create classes?
What does rollup do?