Database Reference
In-Depth Information
Figure 9-49.
Specifying the source information for the Authors dimension
7.
Check the Author Key, Author id, and Author State checkboxes in the Select
Dimension Attributes dialog window (Figure
9-50
).
Figure 9-50.
Selecting the attributes for the Authors dimension
8.
Change the attribute type for the attribute listed here (Figure
9-50
):
•
Author id as Slowly Changing Dimension - original id