The Business Vault contains transformed data (e.g., calculated fields or cleaned addresses).
Data Vault excels at "insert-only" logic. Your tests should mirror this.
Run the same load twice. The system should recognize the data exists and result in zero new inserts. 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."
Insert a record with a modified attribute. Verify that a new Satellite record is created with the updated data while the old record remains (historical tracking). The Business Vault contains transformed data (e
The "Information Mart" layer is where users actually query the data.
You should be able to trace any record in a Star Schema back to its specific Hub and Source system. Run the same load twice
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