Implementing SSIS ETL for Data Vault

This page covers the existing articles and posts to show the process of designing Data Vault models and developing the ETL to populate and read from Data Vault models.

Design:

  • Designing the Logical Model
  • Designing the Physical Model

Data Vault ETL implementation:

Loading Dimensional Models from Data Vault:

  • Loading a Dimension table from a Data Vault model (mixed time-variance)
  • Loading a Fact table from a Data Vault model
  • Virtualising for Type 1
  • Virtualising for Type 2 (and mixed)
  • Dimensional Model placeholders