This SCD type provides a means for viewing historical records of the value prior to an update. This is commonly called versioning. Notice the columns in the top dimension table of Figure 3.16. The SK_ID column is a surrogate key, which is an internal key that identifies the version history of a unique dimensional member….
