SAP (Systems, Applications, and Products) Question:
What is “Extended Star Schema” and how did it emerge?
Answer:
The Star Schema consists of the Dimension Tables and the Fact Table. The Master Data related tables are kept in separate tables, which has reference to the characteristics in the dimension table(s). These separate tables for master data is termed as the Extended Star Schema.
| Previous Question | Next Question |
| What is the difference between OLAP and Data Mining? | Define Meta data, Master data and Transaction data? |