SAP BW Connector > Mappings and Mapping tasks with SAP BW > Troubleshooting for trimming the leading spaces from the data
  

Troubleshooting for trimming the leading spaces from the data

To troubleshoot the trimming of leading spaces from data when you read from DataStore SAP BW objects, configure the retainLeadingSpaces custom property for the Secure Agent.
To configure the retainLeadingSpaces custom property for the Secure Agent, perform the following steps:
  1. 1Log in to Informatica Intelligent Cloud Services.
  2. 2Select Administrator > Runtime Environments.
  3. 3On the Runtime Environments page, select the Secure Agent.
  4. 4Click Edit.
  5. 5In the Custom Configuration Details section, select Data Integration Server as the service and DTM as the type.
  6. 6Enter retainLeadingSpaces in the Name field and set the value to true. The configured retainLeadingSpaces custom property for the Secure Agent to retain the leading spaces from the data.
  7. 7Click Save.