Row by Row Comparison Module

Use the Row by Row Comparison Module to execute Reconciliation tests. This means in-depth comparisons of individual source and target rows.

You can import the Module with the Tosca Data Integrity Modules And Samples.tsu subset.

If you run a 64-bit operating system, you can use both 32-bit and 64-bit ODBC connections. If you run a 32-bit operating system, you can only use 32-bit ODBC connections.

Specify which Row by Row Comparison Module to use in Reconciliation tests

If you have more than one Row by Row Comparison Module in your workspace, you need to specify which Module should be used for your tests. Otherwise, the system uses the first Module it finds.

This is also true if the Row by Row Comparison Modules have different names, since the system uses the configuration parameter SpecialExecutionTask to check for applicable Modules.

To specify a Module, you need to create a configuration parameter for it: 

1. Right-click the respective Module and select Create Configuration Param from the mini toolbar.

2. Name the newly created configuration parameter DIWizardUseInAutocreate.

3. Set its Value to True.

You can switch Modules between tests by deleting the configuration parameter from one Module and adding it to another.

Make sure that only one Row by Row Comparison Module at a time has the DIWizardUseInAutocreate value set to True. Otherwise, the system uses the first Module it finds.