Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between star schema and extend star
schema?
- 11 Answers
- 50519 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 a dashboard in sap bw and how it is created?
What is generally included in the data target administrative task?
as you said you have worked on cubes and ods, which one is better suited for reporting? Explain and what are the drawbacks and benefits of each one?
What is the difference between sap bw 3.5 and 7.0?
How do you install business content AWB?
What is the use of transformation and how the mapping is done in bw?
What are the parameters available in user exit for enhancing master data?
What is an infocube?
Can you tell something about the data ware-house hierarchy?
What are the sap enhancements to enhance fir data?
What is infoobject otpauth?
Explain return tables.
What is an event chain?
What are the minimum no of dimensions in info cube?
What is the conversion routine for units and currencies in the update rule?
