Remove"," from the HANA CV data using SAP DS

[vinay_lohakare5]

Hello Experts,

We are using Replace_substr function in SAP DS to replace "," (comma) from the data coming from HANA DB. We need to remove the "," as the file is loaded in Azure blob in CSV format and if the data coming from HANA CV has "," the data distribution across columns does not happen properly.

The function is causing huge impact on the performance. With function it takes 6hrs and without it it takes 15min to load from HANA CV.

Please let us know if we have a better way of removing the"," in SAP DS.

Thanks,

Vinay Lohakare

[denise_meyer]

Hello,

This is because the replace_substr function cannot be pushed down to HANA to run. So all the work is done in the Data services engine.

https://launchpad.support.sap.com/#/notes/2212730

when you are running with out the replace_substr, likely everything is pushed down to HANA to do the work, which is much faster.

Thanks,
Denise
SAP SUpport