Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between star schema and extend star
schema?
- 11 Answers
- 49681 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 process chain?
What is write optimized dso?
Explain multiprovider?
What is extended star schema?
what is virtual kef figures? what are the uses and in which case supposed to be use?
What steps do you take when you add a new company code to the already running delta datasource ? The datasource is already extracting specific company code delta data , so how will add new company code without disturbing delta
How many types of info sources are there? What are they?
How to create condition and exceptions in bi.7.0?
How do you transform open hub data?
What are the steps in general to enhance data?
What are the naming conventions for aggregates created from statistics?
What is aggregate hierarchy?
What is rowlevel security ? can u please explain with real time example?
What is an infopackage?
What do you mean by start routines
