Validity Tests¶
TestGen validity tests measure how data conforms to predefined business rules, verifying that the data is true to its requirements.
Description and details¶
Alpha Truncation¶
Tests that maximum count of characters in column values has not dropped compared to baseline data.
The system automatically generates this test.
Constant Match¶
Tests that all values in column match the constant value identified in baseline data.
The system automatically generates this test.
Custom Condition¶
Tests that each record in the table matches a predefined custom condition.
This test is not auto-generated. You can create it manually from the Test Definitions page.
Decimal Truncation¶
Tests for decimal truncation by confirming that sum of fractional values in data is no less than sum at baseline.
The system automatically generates this test.
Email Format¶
Tests that non-blank, non-empty email addresses match standard format.
The system automatically generates this test.
Metric Trend¶
Tests that aggregate metric of all or subset of records in a table is within tolerance range.
This test is not auto-generated. You can create it manually from the Test Definitions page.
Minimum Date¶
Tests that earliest date referenced in column is no earlier than baseline data.
The system automatically generates this test.
Minimum Value¶
Tests that minimum value present in column is no lower than minimum value in baseline data.
The system automatically generates this test.
Pattern Match¶
Tests that all values in column match the same alphanumeric pattern identified in baseline data.
The system automatically generates this test.
Reference Match¶
Tests for the presence of one or a set of column values in reference dataset.
This test is not auto-generated. You can create it manually from the Test Definitions page.
Street Address¶
Tests for percent of records matching standard street address pattern.
The system automatically generates this test.
US State¶
Tests that values in column are valid US states.
The system automatically generates this test.
Valid US Zip¶
Tests that postal codes match the 5-digit or 9-digit standard US formats.
The system automatically generates this test.
Valid US Zip-3¶
Tests that postal codes match the 3-digit format of a regional prefix.
The system automatically generates this test.
Value Count¶
Tests that count of unique values in column has not changed from baseline.
The system automatically generates this test.
Value Match¶
Tests that column values match the list of values identified in baseline data.
The system automatically generates this test.
Value Match All¶
Tests that column values match pipe-delimited list of expected values and that all expected values are present.
This test is not auto-generated. You can create it manually from the Test Definitions page.