SCD Types

Slowly Changing Dimensions (SCD) are an important aspect of data warehousing. The two most common types of SCD are Type 1 and Type 2. Which one to use depends on your particular requirements about how to track changes to dimension attributes. In this exercise, you'll identify the distinct characteristics of each SCD Type.