Table validation verifies content of a table matches across the Teradata Database systems. You can validate a table using row count, a validation expression, or both for some types of systems. You can set up table validation manually, with triggers, or as part of a workflow.
Ecosystem Manager includes an Expression Helper to assist you in creating a WHERE clause or a validation expression.
- Row Count
- The Row Count validation method accesses the master cylinder index. Row count indicates tables are synchronized with the same number of rows, but does not confirm the rows have the same values.
- Validation Expression
- The Validation expression lets you create a custom expression to compare the sums of columns in tables. If the custom expression is not an aggregate, Ecosystem Manager places the expression inside a function to make it aggregate. You can use the Expression Helper to insert actions and columns into an expression.
- Partial Table Validation
- The WHERE clause allows you to specify columns to use for table validation instead of the whole table. You can use the Expression Helper to see the available columns.
Before table validation, the metrics are automatically reset to zero. The results of table validation appear on the Tables tab in the Table Metrics view in the Ecosystem Explorer portlet.
For Unity-managed tables, an additional option appears (freeze and activate table when this validation runs). When you check this option, you freeze tables before table validation (state changes to read-only) and activate (state changes to recover) tables after validation. By default, this option is not selected. For tables set up for Unity Passive routing rules, the default option (not selected) is recommended.