What is Slowly Changing Dimension:
Slowly changing dimension used to determine, how the historical changes are handled in warehouse tables.
Consider an example, where the employee address is being changed and the employer want to keep the previous address of the employee, that is the situation where SCD comes into picture. we will discuss in detail about SCD in types of SCD.
Types of SCD:
There are mainly 3 types of slowly changing techniques are there. Please click on them to explore.
SCD Type 2
SCD Type 3
No comments:
Post a Comment