Data Truncation - Database Target

Situation:

When inserting data into my  target database, I'm receiving the following error description in my error record file:

<ErrorDescription><![CDATA[Data truncation in record number: 1]]></ErrorDescription></Record>

I've checked the record field lengths and the data is less than the specified limit for the database fields

Cause:

The data being inserted in to the database fields is too large

Solution

Use the normalize-space mapping function