SCD is the abbreviation of slowly changing dimensions. SCD applies to cases where the attribute for a record varies over time. There are three different types of SCD.
SCD1: The new record replaces the original record. Only one record exists in database – current data.
SCD2: A new record is added into the customer dimension table. Two records exist in the database – current data and previous history data.
SCD3: The original data is modified to include new data. One record exists in database – new information is attached with old information in same row.
No comments:
Post a Comment