on 05-22-2013 7:22 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
We have a similar issue. We see ' ' on Oracle as NULL on HANA. We are not using any SLT conversion.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.