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.
Difference Stage inserted rows not displaying result
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I had removed the unicode for all and still encounter the same problem. However, having a different log warning for each field now.ray.wurlod wrote:Be consistent throughout with the Unicode extended property.
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.joetan wrote:I had removed the unicode for all and still encounter the same problem. However, having a different log warning for each field now.ray.wurlod wrote:Be consistent throughout with the Unicode extended property.
Code: Select all
Difference_71: When checking operator: Dropping component "SRC" because of a prior component with the same name.