<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=931099456970389&amp;ev=PageView&amp;noscript=1">

Category: Slowly Changing Dimensions

1 Results

Easily Handle Transform and Load of SCD2 (Type 2 Slowly Changing Dimensions)

Posted Oct 20, 2017 by Delora Bradish

This blog post is about type two slowly changing dimensions (SCD2). This is when an attribute change in row 1 results in SSIS expiring the current row and inserting a new dimension table row like this --> 


Blog Comments

Need help with this topic? Ask the author below.

 

Subscribe to Blog Updates