How to create Tables and load Flat file data

[Former Member]

This document gives an overview of how to create Tables and then load the flat file data.

**********************************************************************************************************

1.Under your Schema name Select -->'TABLE' Option use context menu option and select --->'NEW TABLE' Option

   

2.Provide the basis details like

• Table Name  :- Provide the Table name (Ex:ZPROD_DETAI)
• Schema        :-Select the name of the Schema
• Type             :-Select the table type (Ex:Column Store)

3.In the next step we have to provide the details for Column Tables

• Name                 :- Name of the Column
• SQL Data Type :-Data type (This can be selected by drop down option)
• Dimension         :Size of the particular column
• Key                    :-Whether this has to be considered as KEY or Not
• Not Null              :- This column shouldn't contatin any Null values
• Default                :-Any default values based on requirmens
• Comments          :- Comments if required

4.Similary provide details for othr table columns and then clik on the button Execute

5.Goto the 'TABLE' Option and use Context menu select -->'REFRESH'

6.In the next step Create Flat File which has to be loaded.(Example Below)

7.Goto either FILE Import option  OR

Select HANA Modeler Perspective and directly click on ‘Import’ option

8.Goto ‘SAP HANA CONTENT’ folder and select -> ‘Data from local file’

9.Select HANA System

10.We will get Below screen :-Select the details as mentioned below.

• Select File             :- File path where the file is saved
• Header row exists :- Number header row to be ignored
• New Schema        :-Schema name under which table is created
• Existing                :-Name of the table Created

11.Click on 'NEXT' and in the next screen we will get an option to mapp the fieds

       Either one to one OR Map by Name

12.Click on One to One so that the Table Columns will be mapped to the Flat File Fields

13.Click on NEXT then we will get below screen and click on FINISH.

14.To view the data loaded.Goto Table Created and Click on Context menu option Select Data Preview

15.Table data can be viewed as shown below