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 figure:
It shows two stars sharing three dimensions: Regions, Manufacturer, and Time. The star model to the left is the SALES star model you already know. The star model to the right does not have data for accessories but has more detail for puzzles, for example, 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:
|
Dimension |
Description |
|---|---|
|
Pieces |
Number of pieces of the puzzle, grouped in the following ranges: 0-25, 26-100, and so on |
|
Theme |
Classification of the puzzle in any of the following categories: Fantasy, Castles, Landscapes, and so on |
|
Glows in the Dark |
Yes/No |
|
3D Puzzle |
Yes/No |
|
Wooden Puzzle |
Yes/No |
|
Panoramic Puzzle |
Yes/No |
|
Packaging |
Number... |
