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.
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
ASK INFAPreview
