Derived Attributes
As we know, some attributes that we might use are not located in the DW. For example, customer age is a function of today’s date and customer’s birth date, so it will change daily. It won’t make any sense to store age in the DW.
In the following slides we’ll create several derived attributes, such as Customer Age, Employee Age and Employee Experience.