Loading Flatfile data into SAP HANA with transformation rules

[Former Member]

Hi All,

I want to load flatfile data (.csv)into SAP HANA database. I want to apply cleansing rules on data like if null then adding default value,date format etc. Please can you let me know how to achieve this.

Thanks in advance.

Thanks,

Indira

[Former Member]

thanks for your replies.

[Former Member]

Hello Indira,

You cannot apply any transformation rules at the HANA system level. You can use tools like BODS to do these transformation rules.

As of now HANA takes only a direct raw flat file load.

Regards,

Sharath

[Saritha_K]

Hi Indira,

you can import a flat file into hana using below steps-

Login to SAP HANA Development - SAP HANA Studio

File

->Import

    ->SAP Hana Content

       ->Data from local file

Here you have 2 options-

1- to insert into a new table

2. you can create a table using sql command in your schema using hana sql editor and try giving the same table name for importing flat file.

(here you have an option of creating your sql table with default values acceptable that you are looking out for.)

Regards,

Saritha K