This page provides an overview of the available posts to show the process of developing ETL to populate and read from Data Vault models using Microsoft SSIS.
Data Vault ETL implementation:
- ETL implementation for the Staging Area
- ETL implementation for the Historical / Persistent Staging Area
- ETL implementation for a Hub and Hub SQL selection
- ETL implementation for a Satellite and Satellite SQL selection (wide tables)
- ETL implementation for Satellite End Dating
- ETL implementation for a Link
- ETL implementation for a Link Satellite (normal relationship attribute history)
- ETL implementation for a Link Satellite (Driving Key relationship history)
- ETL implementation for Link Satellite End Dating
- ETL implementation for Reference tables
- Zero Records
- Dummy records and placeholders