Tag: SSIS

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”

The Work Pile Pattern The Work Pile Pattern is a design approach that can be used to implement elastic horizontal scalability for SSIS processing. In contrast to parallelism that can be hard-coded into the SSIS control flow or data flow (e.g. using the Balanced Data Distributor), a Work Pile implementation allows […] “The Work Pile Pattern”