SAP (Systems, Applications, and Products) Question:

Download Job Interview Questions and Answers PDF

What is “Extended Star Schema” and how did it emerge?

SAP (Systems, Applications, Products) Interview Question
SAP (Systems, Applications, Products) Interview Question

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.

Download SAP (Systems, Applications, Products) Interview Questions And Answers PDF

Previous QuestionNext Question
What is the difference between OLAP and Data Mining?Define Meta data, Master data and Transaction data?