Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between star schema and extend star
schema?
- 11 Answers
- 50133 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 are the options when defining aggregates?
When is idoc data transfer used?
What is rowlevel security ? can u please explain with real time example?
what is sid for to trasport the object along the land scape:/
How will you add buttons to a template?
How will you get more details on data source and delta modes?
What are the do?s and don?ts?
What is the web download scheduler?
Why is one request falls, all the subsequent requests are turned to ?red? in an info provider?
What is the use of rollup?
What is data ware-housing hierarchy?
What is the calculated key figure?
Explain business blueprint stage. What do you do here?
What are the load process and post processing?
In real world when do you recommend aggregate?
