Check that Satellites are correctly attached to their parent Hub/Link and that the Hash_Diff (used for change detection) is calculating correctly. 2. Load Pattern Testing (Technical ETL)
Data Vault should allow for high-concurrency loading. Testing Data Vault-Based Data Warehouse
Run the same load twice. The system should recognize the data exists and result in zero new inserts. Check that Satellites are correctly attached to their
Test the performance of PIT tables; they should significantly speed up the joining of multiple Satellites. Testing Data Vault-Based Data Warehouse
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