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”