Return
-
Title
Data compare is showing a record as missing or additional, even though the tables' primary key -
Description
When doing a data compare, for some records, the primary key column has the same value in both tables, but that record shows as additional in the source table and missing in the target table. It should show it as equal or different instead, since the same primary key column value is there.
-
Resolution
WORKAROUND:
Change the datatypes of the target table from NUMBER to INTEGER.
STATUS:
Waiting for fix to be released in a future version of Toad for Data Analysts. -
Defect ID
ST82743