Use a single-table constraint to run tests on a single table. Single-table constraints define valid data within a table. You can enforce valid values, aggregates, formats, and uniqueness. For example, you might want to verify that no annual salary in an employee table is less than $10,000.
Errors in complex logic often manifest themselves in very simple ways, such as NULL values in the target. Therefore, setting aggregate, value, NOT_NULL, UNIQUE, and FORMAT constraints on a target table is a critical part of any testing plan.
To run single-table constraints, you must create a single table. You can select a relational table, flat file, XML file, lookup view, SQL view, or join view as a single table.
If a single-table constraint fails to run, right-click the single table to retrieve the corresponding session log. View the session log to view errors that may have occurred while running the underlying PowerCenter session.