Data Vault 2.0 Implementation
with Medallion Architecture

The first complete, open-source, end-to-end DV2 + Medallion data warehouse implementation on SQL Server with SSIS. Built for Cambodia's tax administration system.

View on GitHub Read Documentation
67
Database Objects
60
SSIS Packages
49
ETL Steps
6
Databases
58,813
Source Records

Four-Layer Medallion Architecture with Data Vault 2.0

Source (OLTP)       Staging          Bronze (Raw Vault)       Silver (Business Vault)   Gold (Star Schema)
TaxSystemDB    -->  DV_Staging  -->  DV_Bronze            --> DV_Silver            -->  DV_Gold
9 tables            9 tables         9 Hubs (SHA-256)         3 PIT Tables              7 Dimensions (SCD2)
58,813 rows         Watermark        9 Satellites (SCD2)      1 Bridge Table            4 Fact Tables
                    Delta ETL        5 Links                  2 Business Tables         BI-Ready Star Schema

Proof-of-Concept: 4 Challenges Addressed

Schema Rigidity

Add new Satellite without modifying existing objects.

0/67 objects changed, 0/60 packages modified

Historical Tracking

Insert-only Satellites with HashDiff change detection.

All 3 versions preserved with timestamps

Scalable ETL

Step-level error recovery with BatchLog/StepLog.

7/8 steps recovered, 45,065 rows processed

Business Rules

Silver Business Vault separates raw from derived.

Compliance score 72.5%, Risk: MEDIUM

Technology Stack

SQL Server 2025 Developer Edition, SSIS 2022, Visual Studio 2026, T-SQL, SQL Server Agent. All tools are free or included with SQL Server.

Performance

Full load: 91.6 seconds (49 steps). Gold star schema queries run 2.4x to 11.4x faster than raw Data Vault queries.

Keywords

Data Vault 2.0, DV2, Data Vault Implementation, Medallion Architecture, Data Warehouse, Star Schema, Hub Satellite Link, SSIS, SQL Server, ETL Pipeline, Watermark Incremental Loading, Bronze Silver Gold, Business Vault, Raw Vault, Information Vault, SCD Type 2, HashDiff, Change Detection, Audit Trail, Insert-Only Loading, Data Engineering, Government Data Warehouse, Cambodia Tax System, DV2 Medallion, Data Vault SQL Server, SSIS Data Vault, Medallion Data Warehouse, DV2 Implementation, Data Vault 2.0 Tutorial, Data Vault 2.0 Example