what is difference between star schema and extend star
schema?
- 11 Answers
- 46080 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 use of rollup?
when u creating infoobject it shows reference and template what is it
How do you access to source system data in bi without extraction?
What is generally included in the data target administrative task?
Without taking downtime how to fill logistics extractors (2lis types)
What is ?predefined characteristics??
What is 0record mode.
What is the importance of 'start routine' in update rules?
what are the drawbacks of ods?
What are the options for conditions for key figures?
Give an example of master data documentation?
Tell something you know about the dimension in the warehouse and how it can be optimized?
HOW CAN I APPLY PATCHES FOR BI 7.0 WITHOUT USER ID AND PASSWORD OF SAP?
How would you measure the size of a infocube?
what is the component?
