Differences between star and extended star schema ?

A) 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.
B) Extended starschema: Master data tables and their associated fields(attributes). External hierarchy tables for structured access to data. Text tables with extensive multilingual descriptions.

0 comments: