When you compare data between two connections, you can use one of the following comparison methods:
Value Test - Compare Entire Table
If you choose the Value Test - Compare Entire Table method, Data Validation compares the entire table based on the actual data values. This is the default method.
Aggregation Functions Test
If you choose the Aggregation Functions Test method, you can specify the aggregation functions that Data Validation must use to compare the table.
An aggregation functions test retrieves summarized information about the data contained in the data sources. Use aggregation to verify whether all records were moved or to identify incorrect logic in WHERE clauses.
Based on the data type of the columns, you can select one or more of the following aggregation functions:
- COUNT. Counts the number of rows that contain non-null values for a string or numeric column.
- COUNT_ROWS. Counts the number of rows for a string or numeric column. Includes rows that contain nulls.
- MIN. Calculates the minimum value for a numeric column.
- MAX. Calculates the maximum value for a numeric column.
- AVG. Calculates the average value of a numeric column.
- SUM. Calculates the total value of a numeric column.
Note: If either of the tables or columns that you compare doesn't contain data, the Value of Comparison column shows the value as NIL. If both the tables or columns that you compare don't contain data, the Test Result column shows the value as No Comparable Data.