Data Warehouse Manager Question:

Explain me what are the key columns in Fact and dimension tables?

Warehouse Manager Interview Question
Warehouse Manager Interview Question

Answer:

Foreign keys of dimension tables are primary keys of entity tables. Foreign keys of fact tables are the primary keys of the dimension tables.


Previous QuestionNext Question
Explain what is dimensional modeling?Explain any five applications of data warehouse?