Compare Reports Differences for Identical Tables

Issue

When running a Compare job on source and target tables that contain identical data, HVR reports differences instead of reporting the tables as identical.

Environment

• HVR 6
• Source: Oracle
• Target: Amazon Redshift

Resolution

To resolve this issue, define the Environment action on all locations with the following parameters:

• Name=HVR_COMPARE_VARCHAR_PADDING
• Value=1

Cause

Compare orders rows from the source and target tables using the key columns. When key column values differ only by trailing spaces, Oracle and Redshift sort those values differently.

As a result, rows that are logically identical may be returned in different orders by each database. When this happens, we report differences even though the underlying data is the same.