General Datawarehousing Question: Download General Datawarehousing 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.
Previous Question | Next Question |
What is is a Star Schema? | What is a dimension table? |