Extending the sales datamart model
You may, and you usually, have more than one fact table sharing some of the dimensions. Look at the following diagram:
It shows two stars sharing three dimensions: Regions, Manufacturers, and Time. The star model to the left is the sales star model you already know. The star model to the right doesn't have data for accessories, but does have more detail for puzzles such as the number of pieces they have or the category or theme they belong to. When you have more than one fact table sharing dimensions as here, you have what is called a constellation .
The following table summarizes the dimensions added to the datamart: ...
Get Pentaho 3.2 Data Integration Beginner's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
