Ensure "Zero Keys" or "Ghost Records" exist in Hubs to handle late-arriving data or missing lookups without breaking the model. 3. Data Integrity & Reconciliation This ensures that "what went in is what came out."
The "Information Mart" layer is where users actually query the data. 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 Ensure "Zero Keys" or "Ghost Records" exist in
Since Data Vault is pattern-based, the first layer of testing ensures the "plumbing" follows the methodology. it must be validated via query).
Confirm Links correctly map relationships between Hubs. Test for referential integrity (though often not enforced by DB constraints in DV, it must be validated via query).