Application Developer Question:
Download Questions PDF

Explain Extended Star Schema? 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.

Download Application Developer Interview Questions And Answers PDF

Previous QuestionNext Question
Please explain the difference between OLAP and Data Mining?Explain Meta data, Master data and Transaction data?