Testing Data Vault-based Data Warehouse Access

Verify every Hub has a unique business key and no duplicates. Ensure the Load_Date and Record_Source are present.

All source data (even if "dirty") must be stored in the Raw Vault. Testing Data Vault-Based Data Warehouse

Verify that the hashing algorithm (MD5 or SHA-1) produces identical keys for the same business keys across different source systems. 4. Point-in-Time (PIT) & Bridge Table Validation Verify every Hub has a unique business key and no duplicates

Run row counts and sum-checks between the Source Landing Zone and the Raw Vault. calculated fields or cleaned addresses).

Insert a record with a modified attribute. Verify that a new Satellite record is created with the updated data while the old record remains (historical tracking).

The Business Vault contains transformed data (e.g., calculated fields or cleaned addresses).