So far, we have learned about fact tables and dimensions. We described facts as tables containing our measures and dimensions as tables containing descriptive information about our measures. However, we have described them as separate entities.
There is no data model without table linkage. The main purpose of data modeling is to create a performing set of tables -facts and dimensions- so we can join them together.
To understand this better, think of your fact as the structural bone of your model. You load this table first. You learn that fact tables have foreign keys to your dimensions. This means that your fact table is related to your dimensions through these unique identifiers. Fact tables and dimensions are linked through joins ...
