General Datawarehousing Interview Question:

Explain Which columns go to the fact table and which columns go the dimension table?

Submitted by: Administrator

The Primary Key columns of the Tables(Entities) go to the Dimension Tables as Foreign Keys.

The Primary Key columns of the Dimension Tables go to the Fact Tables as Foreign Keys.
Submitted by: Administrator