Data Architect Question:
Download Questions PDF

Tell me what is Star-schema?

Answer:

This schema is used in data warehouse models where one centralized fact table references number of dimension tables so as the keys (primary key) from all the dimension tables flow into the fact table (as foreign key) where measures are stored. This entity-relationship diagram looks like a star, hence the name.

Download Data Architect Interview Questions And Answers PDF

Previous QuestionNext Question
Can you explain me what is meant by Data Analytics?Tell us what is a mini dimension?