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

Cell By Cell Compare Tables Mapping

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

• Cell Level Validation Results.

• Record Count Validations

• Source and Destination key Distributions.

Cell by Cell Comparison Results Overview

Cell by Cell Comparison Stats