Type 1 slowly changing dimension: Overwrite the old value with the new value and call it a day. This is very useful when dealing with issues such as types on the client’s name.
Type 2 slowly changing dimension: Create a new record in the dimension with a new primary key.
Type 3 slowly changing dimension: Overwrite the old value with the new value, and add additional data to the table such as the effective date of the change. This type of slowly changing dimension resolution would be beneficial if there is a change that can happen once and only once.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment