cancel
Showing results for 
Search instead for 
Did you mean: 

HANA converts null as ' '( empty space)

Former Member
0 Kudos

Hi ,

We are bringing the data from oracle to hana using SLT  and observed that null values are converted as ' ' (empty space) .

Can you please suggest if you have any idea on this.

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Venkat

While loading data from oracle to hana using SLT, if you are having null values in oracle system and if you dont want to see the empty spaces in hana, why dont you try using the transformation in SLT to conver the null values to your specified values. i.e. Changing the replication setting in SLT system using IUUC_REPL_CONTENT Tcode.

Below video might help you,

http://www.youtube.com/watch?v=sqfsGkQ2TzQ

Regards

Prashanth

Answers (2)

Answers (2)

0 Kudos

We have a similar issue. We see ' ' on Oracle as NULL on HANA. We are not using any SLT conversion.

lbreddemann
Active Contributor
0 Kudos

Is this an empty string or is it one space?

How do you get data from Oracle to HANA in your case?

Be aware that there are documented differences in the way both platforms handle empty/zero-length strings and NULLs.

Former Member
0 Kudos

Venkat -

Were you able to convert the data from your Oracle system back to NULL using the SLT transformation functionality?    We are dealing with a similar issue.

Thanks,

Katie