How do i set to Space/Blank on HANA table-datatype as CHAR with Data-Services.
I am trying to load the HANA table. The source is a extract (Fixed Flat file) of a Mainframe DB2 table. After i extract i am running the following DS dataflow.
Flatfile-->Tablecompare(Filefile data Vs Hana table) and then create 3 files.(Insert,Update,Delete) and uses these files to load the hana table.
All the columns which has blanks on flat file are being loaded as Nulls to HANA table. How can i stop this and load the blanks to the table?
Any suggestion will be of great help.