ETL Testing/Cell By Cell Compare

This compare option will compare the data, or columns, of the source and target tables on various checks.

To create a Cell By Cell Compare flow:

• Drag a Source component from the palette to the canvas.
• Choose the Input Source Configuration and select the tables to compare.
• Drag a _Target _component from the palette to the canvas.
• Choose the Input Source Configuration and select the tables to compare
• Drag a Data Compare component and join the connections.
• Select ETL Testing/Cell By Cell Comparison from the drop-down menu that appears at the bottom of the screen.
• Select the primary key. By default, the primary key is selected for the tables. If the key is not selected, the system shows a warning sign for the user to select the Primary Key.
• Save and execute the flow.

Data Compare Options

Vexdata can compare the selected source and destination tables to view:

• Cell Level Validation Results.
• Record Count Validations
• Source and Destination key Distributions.