Saved Bookmarks
| 1. |
Differences Between Star And Extended Star Schema? |
|
Answer» Star SCHEMA: Only characteristics of the dimension tables can be used to access FACTS. No structured drill downs can be created. SUPPORT for many languages is difficult. Extended star schema: Master data tables and their ASSOCIATED fields (ATTRIBUTES), External hierarchy tables for structured access to data, Text tables with extensive multilingual descriptions are supported using SIDs. Star schema: Only characteristics of the dimension tables can be used to access facts. No structured drill downs can be created. Support for many languages is difficult. Extended star schema: Master data tables and their associated fields (attributes), External hierarchy tables for structured access to data, Text tables with extensive multilingual descriptions are supported using SIDs. |
|