Data Architect Question: Download Questions PDF
Tell me what are the different design schemas in Data Modelling? Explain with the example?
Answer:
There are two different kinds of schemas in data modeling
Star Schema
Snowflake Schema
Now I will be explaining each of these schemas one by one.
The simplest of the schemas is star schema where we have a fact table in the center which references multiple dimension tables around it.
All the dimension tables are connected to the fact table. The primary key in all dimension tables acts as a foreign key in the fact table.
Star Schema
Snowflake Schema
Now I will be explaining each of these schemas one by one.
The simplest of the schemas is star schema where we have a fact table in the center which references multiple dimension tables around it.
All the dimension tables are connected to the fact table. The primary key in all dimension tables acts as a foreign key in the fact table.
Download Data Architect Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Explain me non-additive Measures? | Can you distinguish between OLTP and OLAP? |