Skip to Content

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

    FF1.jpg

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)

FF2.jpg

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

FF3.jpg

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

FF4.jpg

5.Goto the ‘TABLE’ Option and use Context menu select –>’REFRESH’

FF5.jpg

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

FF6.jpg

7.Goto either FILE Import option  OR

FF7.jpg

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

FF8.jpg

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

FF9.jpeg

9.Select HANA System

FF10.jpeg

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

FF11.jpg

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

FF12.jpg

FF13.jpg

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

FF15.jpg

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

FF14.jpg

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

FF16.jpg

15.Table data can be viewed as shown below

FF17.jpg

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply