Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between star schema and extend star
schema?
- 11 Answers
- 50562 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / pranith kumar chakilam
star schema
1.It can be analysed only in 16 dimensions.
2.Master data is not reusable.
3.performance is degraded because of the alphanumeric
values in the fact table.
Extended Star Schema
1.It can be analysed in 16*248 dimensions.
2.Master data can be reusable as it is not inside the cube.
3.Better performance as there r no alphanumeric values in
the fact table.
| Is This Answer Correct ? | 20 Yes | 4 No |
Post New Answer View All Answers
What is the format of LO data sources?
What is a dashboard in sap bw?
What is the index?
is their any difference between bex 3.5 and bex 7.0?
please tell me the most frequently asked interview questions about sap BW with answers
Give some examples of usage of BW statistics reports?
What is geographical information in the sap bw?
What are the different categories of infoobjects in bw system?
What is an exception cell?
How the dimensions are optimized?
What is the function of bw statistics cube?
What are the conversion routines for units and currencies in the update rule?
what is a multiprovider? what are the uses and in which case supposed to be use? difference between bi7.0/bw3.5?
What is the use of transformation and how the mapping is done in bw?
remodeling is applied only on info cube? why not dso/ods?
