Database Reference
In-Depth Information
Figure 4-15.
A role-playing dimension
Parent-Child Dimensions
Parent-child dimension tables look like their OLTP counterparts. The classic example of a parent-child
dimension is an employee table where the relationship between employees and managers is mapped by
associating a manager ID (parent) to an employee ID (child). To create a parent-child dimension table in the data
warehouse, all you need to do is use the same design as you would in an OLTP environment, much as the one you
see in Figure
4-16
.
Figure 4-16.
A parent-child dimension
