Assigning Validation to Tables in Bulk - Teradata Ecosystem Manager

Teradata Ecosystem Manager User Guide

Product
Teradata Ecosystem Manager
Release Number
16.00
Published
December 2016
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
qae1470238875438.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-3201
lifecycle
previous
Product Category
Analytical Ecosystem
  1. Click next to Tables.
  2. Click Bulk Assign Validation.
  3. Click .
  4. Select the box next to each database and table to bulk assign validation, and then click . The selected tables appear on the right side.
  5. Click OK.
  6. Click the scheduler to enter the Validation Frequency.
    1. Select the how often to repeat the validation.
    2. Select the day to start the validation on.
    3. Select the time to start the validation.
    4. Click OK.
  7. Enter the WHERE clause.
  8. Enter the Validation Expression or select the Row count flag box if you want to compare the number of rows in tables across Teradata Databases. For table validation on Hadoop or Aster systems, the validation expression technique is not available. The field Hadoop rowcount column is applicable for table validation involving a Hadoop system.
  9. [Optional] If you check the Row count flag, choose how to define validation failure.
    • Use base tables rules. Base table rules are global rules defined in the Manage Synchronization Rules view.
    • Use a custom rule to enter the limit for the row count difference across systems. You can enter a whole number or a percent value with decimals. For example, 1,200, 10% or 5.23% are acceptable.
  10. Set up an alert if validation fails.
  11. Click Apply.