Preserve trailing blanks property
Use the Preserve trailing blanks property to specify whether the stage preserves trailing white space characters in the text field values of the records that it passes to the database.
Usage
This property is available for all modes that are available in the Write mode property, including the bulk load mode. The property applies to the input link columns and key columns on the reference link that have the character data types, such as VarChar or NVarChar.
You can set the Preserve
trailing blanks property to the values that are listed
in the following table.
| Value | Description |
|---|---|
| Yes | The trailing white space characters are treated the same as any other characters. They are preserved along with the other characters, and the data is passed to the database in its original form. This behavior is the default for the connector. |
| No | The stage removes trailing white space characters from the text field values. The trimmed values are passed to the database. Any leading white space characters in the values are preserved. |