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.

Anil SAP Gupta

Published on 09-Apr-2018 19:38:28

• Related Questions & Answers
• Table type while importing data from flat file in SAP HANA
• Table mapping while data replication from flat file in SAP HANA database
• Different options in Data Preview in SAP HANA
• Importing data from Pgsql to SAP HANA database
• Using flat file load in SAP HANA database
• Different options under SAP HANA System Administration
• Different options in customizing SAP HANA Studio Perspective
• Authentication options in SAP HANA while adding new system
• Using header rows during flat file upload in SAP HANA
• Using different Projection options in Calculation view in SAP HANA
• Using Schema mapping in SAP HANA
• Setting schema mapping in SAP HANA
• Importing limited number of rows from CSV in SAP HANA
• Performing different SAP logon check while connecting to HANA
• Folder options in SAP HANA Studio