Database Reference
In-Depth Information
Figure 12-38.
Testing the reference dimension
eVeN MOre DIMeNSION CONFIGUratIONS
many other dimensional configurations are possible, such as configuring slow changing dimension (sCd)
attributes. These dimensions require additional columns in the data warehouse tables for tracking changes
over time. For example, we could modify the dimTitles table to look like Figure
12-39
.
