You should be able to trace any record in a Star Schema back to its specific Hub and Source system.
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
Data Vault excels at "insert-only" logic. Your tests should mirror this. You should be able to trace any record
Verify every Hub has a unique business key and no duplicates. Ensure the Load_Date and Record_Source are present. Testing Data Vault-Based Data Warehouse
You should be able to trace any record in a Star Schema back to its specific Hub and Source system.
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
Data Vault excels at "insert-only" logic. Your tests should mirror this.
Verify every Hub has a unique business key and no duplicates. Ensure the Load_Date and Record_Source are present.