DBA > Job Interview Questions > Data Warehousing Interview Questions and Answers

Which columns go to the fact table and which col

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

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

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.

(Continued on next question...)

Other Job Interview Questions