Data Architect Question: Download Data Architect PDF

Tell me what is Star-schema?

Tweet Share WhatsApp

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 PDF Read All 41 Data Architect Questions
Previous QuestionNext Question
Can you explain me what is meant by Data Analytics?Tell us what is a mini dimension?