Skip to content
Data Engine Thinking Data Engine Thinking Samples

Testing

Testing in the integration layer ensures data quality and consistency across all loaded entities. A robust testing framework validates that business rules are enforced and that data integrity is maintained throughout the loading process.

Key testing areas in the integration layer:

  • Uniqueness: Uniqueness controls to ensure business keys and surrogate keys remain unique: example.
  • Completeness: Completeness in temporality to verify all expected records are loaded: example.
  • Referential integrity: Validation that all foreign key relationships are satisfied: example.

Recording the outcome of multiple checks in a single integer — so each consumer can apply its own quality standard — is documented as the Solution Pattern - SQL Server Family - Exception Bitmap.