Fig. 12.1.12 Star joins.In the dimensional model are found fact tables and dimension tables. Tables and
dimension tables are attached together to form what is known as the “star” join. The star
join is designed to be optimal for the informational needs of a department.
The data marts and the data warehouse combine to form an architecture, as seen in Fig.
12.1.13.
Chapter 12.1: Operational Analytics