¶ Description
Validate/Compares two tables.
¶ Parameters
¶ Parameters tab
Parameters:
- String or unknown validation columns
- Number of validations columns
- Threshold in numbers comparison
- Short decription of the test performed
- Abort execution on Error
- Treat NULL as the sdame as a Zero-Length String
¶ Description tab
Parameters:
- Script name
- Short description
- Revision
- Description
¶ Configuration tab
See dedicated page for more information.
¶ About
This operator compares the 2 tables given on the 2 input pins. ETL checks if the 2 tables are identical. Only the selected columns will be compared.
The output of this operator is one unique row that contains:
- In the first column: the user-supplied short description of the performed test.
- In the second column:
- If the comparison is successful (i.e. the selected columns of the 2 tables matches), then you obtain, the string OK.
- If the comparison failed, then you obtain a short description of the mismatch.
