Intentionally feed "bad" data into the pipeline to ensure it is caught by error Satellites rather than crashing the load. Success Metrics (KPIs)
Validate that business rules applied in the Business Vault match the requirements. Testing Data Vault-Based Data Warehouse
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." Intentionally feed "bad" data into the pipeline to
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
All source data (even if "dirty") must be stored in the Raw Vault.