Intentionally feed "bad" data into the pipeline to ensure it is caught by error Satellites rather than crashing the load. Success Metrics (KPIs)

Test the performance of PIT tables; they should significantly speed up the joining of multiple Satellites.

The "Information Mart" layer is where users actually query the data.

Data Vault should allow for high-concurrency loading.

Validate that business rules applied in the Business Vault match the requirements.

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

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).

Leave a Reply

Your email address will not be published. Required fields are marked *

Post comment