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
You should be able to trace any record in a Star Schema back to its specific Hub and Source system. Testing Data Vault-Based Data Warehouse
The Business Vault contains transformed data (e.g., calculated fields or cleaned addresses). Verify that the hashing algorithm (MD5 or SHA-1)
Query a PIT table for a specific date in the past. Verify it correctly identifies the "active" Satellite records for that timestamp. 5. Business Vault & Logic Testing Testing Data Vault-Based Data Warehouse