The dimensional model consists of a fact table and multiple connected dimensions. The
result is what is termed a “star join.”
Fig. 14.1.10 depicts a star join.
Fig. 14.1.10 A star join.The star join reflects the needs of the different departments that will be using the data
influenced by the star join. Stated differently, there will be a star join for marketing.
There will be a different star join for sales. There will be another star join for finance, one
for marketing, and so forth.
The reason why there will be a different star join is that the different departments look at
data differently. The star join for a department reflects the customized view of data for
the department.
Fig. 14.1.11 shows that there are different star joins for each department.
Chapter 14.1: Data Models Across the End-State Architecture