Compare Pairs

A compare pair is the logical relationship between a source table or file and a target table or file for the purpose of comparing their data. Compare pairs are linked to groups. As a reason, all of the source and target objects that you configure into compare pairs for any given group must be accessible from the datasource connections that are associated with that group.

The Groups and Compare Pairs page lists the following details of the Compare Pairs created for that particular Group.

• Enabled: By default, all the compare pairs are enabled. You can toggle this switch to disable the selected Compare Pair. You can select the compare pairs to be included in the Group by toggling the Enabled switch, and then click Save to save the Group and Compare Pairs details.

• Compare Pair Name: The default name format is <source>=<target>. If you hover the mouse cursor over a Compare Pair name, the actual source and target object names are displayed.

• Source Table: The source table in the Compare Pair.

• Target Table: The target table in the Compare Pair.

• Delta Processing: See Delta Processing

• Validation Status: By default, the Validation Status is Never Validated. See Validate Column Mapping. After you select the Compare Pair and click Validate Column Mapping, the Validatation Status of the selected Compare Pair gets updated to Validated. You can also select multiple Compare Pairs and click Validate Column Mapping to validate their status.

• Actions: You can delete the selected compare pairs by clicking the Delete icon. See Deleting a Compare Pair

Use the Compare Pair section on the Groups and Compare Pairs page to do the following:

• Add Compare Pairs

• Validate Column Mapping

• Enable Delta Processing

• Delete Compare Pairs

• Compare Pair Details