TestGen Test Types

This reference covers the 48 test types available in TestGen. Each test type targets a specific data quality concern — from missing values and format violations to statistical shifts and cross-table inconsistencies. Use this page to understand what each category of tests checks and to find the right test type for a manual test definition.

Data quality dimensions

Each of the 48 test types represents at least one data quality dimension.

Data quality dimension	Description	More information
Accuracy	Measure data that attempts to model real-world objects or events by comparing it with information known to be correct.	Accuracy Tests
Completeness	Verify that all required records and values are available with no missing information and that the data is 100% complete.	Completeness Tests
Consistency	Ensure that data does not conflict with itself.	Consistency Tests
Timeliness	Measure data timing against predicted or desired timings.	Timeliness Tests
Uniqueness	Ensure that data is unique only to itself.	Uniqueness Tests
Validity	Measure data conformity to pre-defined values.	Validity Tests

Tip

To learn more about test categorization — and how TestGen aligns with database best practices — see the article, Data Quality Dimensions.

Custom tests

TestGen also supports a CUSTOM test type that allows you to define any business rule as a SQL query. Custom tests can be created manually from the Test Definitions page. Any row returned by your query is interpreted as a single error condition.