Question

What are the key columns in Fact and dimension tables?

Answer 1

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