what is difference between star schema and extend star
schema?
- 11 Answers
- 46764 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / aviroop
Star schema is a special case of snowflake schema. Here,
the fact table is surrounded by dimension master data
tables inside the Cube. Bt its extended schema version
further breaks up the dimension tables of star schema into
dimension Id table and master data table. It simplifies and
increases the database accessibility for other cubes to
make it more robust.
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
what is the component?
In real world when do you recommend aggregate?
What is ud connect in sap bw system? How does it allow reporting in bi system?
What is the use ':' as an authorization value?
What are the precautions to generate a report on DSO in sap Bi?
what are the data types for the characteristics info object?
Explain the architecture of the sap bw system?
Where do we use write optimized dso?
What is bw statistics and how it is used?
Why is one request falls, all the subsequent requests are turned to ?red? in an info provider?
What are processing commands?
What is the use of infocube in the bw system?
How the dimensions are optimized?
What are the combined tests?
How do you enter data in real-time infocubes?
