Run the same load twice. The system should recognize the data exists and result in zero new inserts.

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.

The Business Vault contains transformed data (e.g., calculated fields or cleaned addresses).

All source data (even if "dirty") must be stored in the Raw Vault.