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.

Last updated