Re: DBCErrorCode

For example, if the data types change then perhaps the data becomes duplicate, e.g. '00', '0','' all could map to an integer value of 0.

Or perhaps the source system is case-specific for string comparisons and your target is defined / defaulted to NOT CASESPECIFIC.

Or you may have VARCHAR data that differs only in trailing spaces (which are not significant in standard / Teradata SQL; but Oracle, in particular, considers different numbers of trailing spaces to be different values).