Testing Data Vault-based Data Warehouse <Desktop>

Run the same load twice. The system should recognize the data exists and result in zero new inserts.

Test the performance of PIT tables; they should significantly speed up the joining of multiple Satellites. Testing Data Vault-Based Data Warehouse

Data Vault excels at "insert-only" logic. Your tests should mirror this. Run the same load twice

Data Vault should allow for high-concurrency loading. Testing Data Vault-Based Data Warehouse

All source data (even if "dirty") must be stored in the Raw Vault.

Run row counts and sum-checks between the Source Landing Zone and the Raw Vault.