Updating Type 6 Slowly Changing Dimension Attributes

This post completes my mini-series on implementing the Kimball-based SSIS patterns described by John Welch in his SQLBits session on Handling Advanced Data Warehouse Scenarios in SSIS.

The task here is how to best implement inserts and updates to slowly changing dimensions with Type 6 […] “Updating Type 6 Slowly Changing Dimension Attributes”

Inserting into Large Parent Child Dimensions

In this post I’m implementing another of John Welch’s patterns from his SQLBits session on Handling Advanced Data Warehouse Scenarios in SSIS.

It’s an efficient pattern for performing inserts into large parent child dimensions that delivers its speed through only having to do 2 passes over the source data. It […] “Inserting into Large Parent Child Dimensions

Inserting Facts with Late Arriving Dimensions

In John Welch’s SQLBits session on Handling Advanced Data Warehouse Scenarios in SSIS, he describes a pattern for handling late arriving dimension members for dimensional data warehouses.

The pattern is oriented around high performance, and so avoids row-by-row SQL updates and non-cached […] “Inserting Facts with Late Arriving Dimensions”