General Datawarehousing Question: Download Questions PDF
Explain Which columns go to the fact table and which columns go the dimension table?
Answer:
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.
The Primary Key columns of the Dimension Tables go to the Fact Tables as Foreign Keys.
Download General Datawarehousing Interview Questions And Answers
PDF
Previous Question | Next Question |
What is is a Star Schema? | What is a dimension table? |