Dimensions that change over time are called Slowly Changing Dimensions. For instance, a product price changes over time; People change their names for some reason; Country and State names may change over time. These are a few examples of Slowly Changing Dimensions since some changes are happening to them over a period of time.
Slowly Changing Dimensions are often categorized into three types namely Type1, Type2 and Type3. The following section deals with how to capture and handling these changes over time.
The "Product" table mentioned below contains a product named, Product1 with Product ID being the primary key. In the year 2004, the price of Product1 was $150 and over the time, Product1's price changes from $150 to $350. With this information, let us explain the three types of Slowly Changing Dimensions.
Product Price in 2004:
Product ID(PK) Year Product Name Product Price
1 2004 Product1 $150
1.SCD TYPE1(Slowly Changing Dimension) : contains current data.
2.SCD TYPE2(Slowly Changing Dimension) : contains current data + complete historical data.
3.SCD TYPE3(Slowly Changing Dimension) : contains current data + one type historical data.
Learn Informatica, Informatica PowerCenter at BigClasses by very experienced and industry experts. https://bigclasses.com/ or Email us at firstname.lastname@example.org