torstai 28. helmikuuta 2013

Uploading Flat file in SAP HANA

In this document, I'm trying to explain “how to upload a Flat file in SAP HANA”

1. Choose Start all programs and select SAP HANA STUDIO


2. From content menu select Import, expand the SAP HANA Content directory and select Data from Local File and choose Next.


3. In the Flat File upload Screen, browse for the file which should be uploaded into SAP HANA database. If a header row exists in the flat file, select Header row exists and enter row number and select check for Import all data.

From the target table, Choose New and select SULABH schema and entered Work_Distribution as table name.


4. In the Manage table definition and data mapping screen, it’s possible to map the source and target column.
Note: It’s required to select a key


5. It’s possible to preview the data based on the flat file screen and select finish to finalize the creation process.


6. Now, we can view created table (Work _Distribution) in SULABH schema.


Sulabh Bartaula 
SAP HANA certified consultant 
+358 40 4163 717 
sulabh.bartaula@sapfox.com

Ei kommentteja:

Lähetä kommentti