SLOWLY CHANGING DIMENSION, is an SSIS transformation which can solve problems for dimensions whose attributes are changing by the time, and needs updates in future. Normally once the data is loaded into DWH , we need cleaning during the process. For this purpose we can use inbuilt transformation also, i.e. lookup, fuzzy lookup etc. as well as one can make self built logic using SQL queries or may be by using other built in SSIS transformations. In same way to perform SCD logic three pipelines are needed: 1) Do lookup in order to find the new rows from the source. 2) Make logic using timestamp or hash byte values to recognize the updates in any row, based on the matching record values. 3) And for inferred member rows, need to have new pipeline, checking for inferred rows in dimension table, and according get updates from source. Moreover, making separate logics and then simply save the package for future references will be a better option as compared to directly using SCD....