SAP Data Services is removing trailing spaces.

dataservices job design
1

Hi ,

I am extracting the Data from Sybase ASE database.

I have data in the source like "scb000012 " & “scb000012” . One value with trailing space and another one without trailing space. In the source I can see the length of these two strings 10 & 9 respectively.

But while extracting the data it is removing the trailing space and it is showing length of the both strings have same length. This field is key field in my source. I cannot load this data as it is showing duplicate due to removed the trail blank space for the first string.

I want to retain the space as source database have .

Please help me any option need to change to retain the blank space.

Thanks & Regards,

Ramana.

Ramana :india: (BOB member since 2009-04-30)

2

Try to place some special character instead of space and then after extract replace that special character again with space… or try to use to_text function or chr function which ever supports to retain your space as it is… also check if there are any trim functions used while extract…

surya.g :india: (BOB member since 2009-11-24)

3

Hi Surya,

I cannot replace any special character in the operational database.

While extraction itself removing the trail blank space. If it is in transformation phase we can handle with replace any special character.

Thanks & Regards,
Ramana.

Ramana :india: (BOB member since 2009-04-30)

4

Hi Ramana,

In one of requirement the user wanted ‘?’ before the value and i have used ‘?’||followed by source field.

in your case use ’ '||followed by source field in the filed level mapping at query transform may work

sam1984 (BOB member since 2014-06-17)

5

As far as I remember we changed the DSconfig.txt parameter(not sure exactly which) to tell DS whether the trailing spaces should be trimmed or left untouched.

BODSDW (BOB member since 2011-01-19)

6

Hi,

In the DS Config we have below options regrading blank spaces.

Treat_Oracle_Bulk_Loader_Blank_As_Null = YES

XML_LOADER_REPLACE_NULL_OR_BLANK = ActaWorks_system_default_behavior
LOADER_REPLACE_NULL_WITH = (null)
LOADER_REPLACE_BLANK_WITH = -null-

XML_LOADER_REPLACE_NULL_OR_BLANK = yes

Please suggest me which one will help to avoid this issue.

There are options specific to database and xml only.

Thanks & Regards,
Ramana.

Ramana :india: (BOB member since 2009-04-30)

7

hello,

We’re facing the exactly same issue, with Sybase ASe sources and not with others types of source, for instance SQL Server.

Did anyone find a solution to this? We’re upgrading from DS 4.1 to DS 4.2 SP8

Regards,

Andrés

aidelia :argentina: (BOB member since 2006-02-02)