SSIS Slowly Changing Dimension Type 2
The SSIS Slowly Changing Dimension transformation coordinates the inserting and updating of records in data warehouse dimension tables. This transformation supports four types of changes, and in this article, we will explain SSIS Slowly Changing Dimension Type 2 (also called SCD Historical attribute or SCD 2). SSIS Slowly Changing Dimension Type 2 (SCD 2): If … Read more
