Data Warehousing: Slowly Changing DIMENSIONS

摘要

Adding a record to capture this change in flow rate is the technique most often used to track measurable values, such as employee job performance, customer status, and product availability. When employing a type 2 response, you must use a surrogate (e.g., the SQL Server IDENTITY property) for the primary key because you'll have multiple versions of the same record as that record changes over time.