Monthly Archives: March 2014

Generating a Type-2 Dimension from Multiple Tables with Effective Dates

Posted on March 18, 2014 by Bob L

In slowly changing (SCD) dimensions, type-2 attributes involves ending a dimension row when the attribute value changes with the current date and creating a new row starting from the current date. While this works great to capture history once a … Continue reading →

Posted in Uncategorized | Leave a comment