SSIS Tutorials - 14.Slowly Changing Dimensions in SSIS - Type 1, Type 2 and Type 3
SCD or Slowly Changing Dimension it is one of the component of SSIS toolbox.
This component is used if you want insert or update data records in dimension tables.
Simplest explanation can be it compares incoming source data with existing destination dimension table data using a Business Key (Unique Key).
and SCD consist of three types.
Last but not the least, SUBSCRIBE to my YouTube channel to stay updated about the regularly uploaded new videos.
My channel : / @melvinking7477
Linkedin : / mohammed-rasool