DSXchange

I use the Difference Stage to output inserted, changed and deleted records from 2 dataset files. There are two problems with the output files.
Inserted records(0) - showing up as null or no value in the output file
Changed records(3) - the before data was display instead of after data

The following options are set in the difference stage:
All non-Key Columns are Values=True
Drop Output for Insert=False
Drop Output for Delete=False
Drop Output for Edit=False
Drop Output for Copy=True

There are 1 warning for each field in the log files. This is one of them
TRANSFORMfile: When checking operator: When binding output schema variable "outRec": When binding output interface field "ABCDEF" to field "ABCDEF": Implicit conversion from source type "ustring[max=3]" to result type "string[3]": Possible truncation of variable length ustring when converting to string using codepage UTF-8.

Appreciate any help please.

Be consistent throughout with the Unicode extended property.

ray.wurlod wrote:Be consistent throughout with the Unicode extended property.

I had removed the unicode for all and still encounter the same problem. However, having a different log warning for each field now.

joetan wrote:

ray.wurlod wrote:Be consistent throughout with the Unicode extended property.

I had removed the unicode for all and still encounter the same problem. However, having a different log warning for each field now.

Code: Select all

Difference_71: When checking operator: Dropping component "SRC" because of a prior component with the same name.

I'm using the change capture stage instead of the difference stage. Works beautifully now.