I am facing some weird challenge while inserting a record in the target table on using the transform

[snow57]

Hi Team,

I have a field of length "255" and while inserting the record using transform map it , the field is not updating the whole text using the transform map. and while inserting the record using the background scripts I can able to do the whole text . and if I do the same thing with another field that has a length of "4000," I can do the full text. 

Did anyone faced the same thing ? Please try to help me on this .

Ex: Text support - 1234 ServiceNow User  -- String to be update.

Text support - String updating the transform map

Text support - 1234 ServiceNow User  -- String updating using the background script.

Note : used trim() while transformation but no use. 

Thanks,

Snow.

[snow57]

Hi Prasad,

Thanks for responding.Tried the above things . But its not the solution.

Regards,

snow.