Blanks from SAP ECC not populated as blank/null at Oracle Tgt

[Former Member]

Hi,

I am dumping data from ECC to Oracle 11g via SAP BODS 4.1

Columns with blanks are neither populated as blanks nor as null at oracle target table.

However, BODS recognizes the blanks. This is because, when I give a decode function in query transform i.e decode(column=' ', '$',column) , this populates the target with '$'.

When I try to populate directly, Both the below queries return no results.

Select * from ORacle_TGt where column is null

Select * from ORacle_TGt where column=' '

Even on the webi reports, this column is neither seen as NULL nor as Blanks.

Datatype of the column is Varchar(1). Pls help on populating the blank values directly from ECC.

Thanks.

[former_member442248]

Hi Saurabh.

Not required to go to DS Config. Go to Tools --> SAP and select the checkbox.

Regards.

Shaz