Tagged: SQL


Data Vault ETL Implementation using SSIS: Step 3 – Hub ETL – part 2 – SQL selection

The outline ETL for Data Vault Hub style ETL using SSIS has been documented in ‘Hub implementation’ and ‘Hub exceptions’. As a minor addition I would like to dive a bit deeper into the selection logic associated with Hub ETL. Following the experiences ‘from the trenches’ there are basically two ways to create SQL for a Hub selection from the Staging Area; Straight-up selection of the business key Selection including a composite business key (e.g. assembled from...