I'm having an issue where varchar fields with direct mapping are trimming leading, trailing and internal double spaces ... sometimes. I write sometimes because it doesn't always happen.
Here's some of the suss data:
Code: Select all
CONTACT1_NAME|contact_name
KAY -VICTORIA PAM -KAVANR|KAY -VICTORIA PAM -KAVANR
MR PAUL COOPER|MR PAUL COOPER
MRS BEVERLEY FRIEDMAN |MRS BEVERLEY FRIEDMAN
MR PAUL / CASTLE SCHOENAVER / RACHEAL|MR PAUL / CASTLE SCHOENAVER / RACHEAL
JANINE ROISSETTER|JANINE ROISSETTER
Job logic is:
ODBC Enterprise ->
TRF ->
some lookups ->
Chksum ->
TRF ->
ODB Connector
the contact1_name field is mapped to contact_name in the first transformer directly with no changes and then carried through without change.
Contact1_name is varchar(180), contact_name is varchar(255).
I'd just write it off as things happen, except they don't all the time.
Things to try, look at or investigate would be greatly appreciated.