Different mapping options in SAP HANA while importing data from flat file

In SAP HANA, using file import you can load data to an existing table or can create a new table with the same column names as in the flat file.

While using import wizard, you can define the mapping of columns. Following options are available −

  • One to One
  • Map by Name

Using Map by Name option, you can map columns in CSV files to the columns in an existing table.