Data is getting trimmed in Trunc Load of OE stage

[parthajit]

Hi All,
I am Loading Oracle tables using Oracle Enterprise Stage. Write Method =Load and Write Mode=Truncate

Incoming Data has Trailing Space. Need to load data as it is coming from source. But in target the data is getting Trimmed. So far what I observed that, this truncation of data is only happening while Loading Data in Data base by Bulk load mode not in any othere stage.

Is there any options in Oracle Enterprise Stage, so that I can use Write Method =Load and Write Mode=Truncate and avoid this truncation


Thanks and Regards

[chulett]

Set $APT_ORACLE_PRESERVE_BLANKS to true to override that default sqlldr behaviour.

[parthajit]

Thanks.... Its working