Delta Project Creation in SAP Hana

Loading data from SAP ERP: (Delta)

Create data store for HANA DB

Create a data store for R3  

Steps as SAP ECC6 level:

Log on to ECC6

Go to provide 7 – Code RSA file

Select Required Extractor

Activate

Again go to RSA6 T-Code

Select Recently activated extractor

EDIT and make any changes based on requirement and save it  

Steps at Data Services:

Import our extractor into SAP Application Datastore (Enable CDC Option)

Import our HANA DB table into the HANA DB store

Create a project

Create a job

Create workflow

Create data flow

Drag extractor

Take query transformation

Drag our HANA DB Table

Connect extractor of query transformation

Connect HANA DB table & Query transformation

MAP the fields of extractions & table

RUN the job

Execute the job

Loading data from dynamic files to SAP HANA

Create data store for HANA DB

Import out Required our Target area

Bulk loading from source table by using data services  

Design Data services first load the data into a staging table and then it applies the operation codes (INSERT, UPDATE, and DELETE) to update the target table. With the Bulk – load option selected in the table editor, any one of the following conditions triggers the staging mechanism The data flow contains a Map – CDC operation transform Y the data flow contains a map – operation transform that outputs update or DELETE rows Y the data flow contains a table – comparison trans for Y the auto-correct load option in the target table editor is set to yes  

Settings Template tables For template tables, select the appropriate table type for your SAP HANA target Y column store (default) Y Row store

Target options bulk loader options load pre-load post – load  Triggers pre-load commands post –load commands Rows per commit: Delete data from the table before loading: Drop and re-create table :  

Advanced Generate column comparison No.of loaders compare by name 1 Error handling use overview flow NO Filename Not Applicable File format Not Applicable Update control use input keys NO Update key columns NO Update auto-correct load NO  

All Table When bulk loading is enabled, you have the following options: Models specify the mode for loading data to the target table Append :adds new records to table (default) Truncate : deletes all existing records in table then adds new records Commit size – the maximize no. of rows loaded to the staying and target tables before saving the date Column store (default commit size is 10,000) Y Row store (default commit size is   1,000) Y update Method – specify how the input rows are applied to the target table Y update issues an UPDATE to the target table (default for column store tables) Y DELETE – INSERT : issues a delete to the largest table for date that matches the old data in the staying table, then issues an INSERT with the new data (default for Row store tables) Do not delete –insert if the update rows do not contain data for all columns in the target table been at a  services will replace missing data with NuLLS Target options bulk loader load triggers pre – load commands post load commands co Bulk loader Mode : Appeared Commit side: Update method:  

Dynamic flat (FF) file selection Using valuable: We can extract the file dynamically we can use the variable go-to workbook       new     Format name : Directory: It is used mostly enter the File Name: File name so it cant import data then we will enter the fields name and data type and size

A variable is a job-specific (Group of WF and DF) Select Job go-to tools    create variables We select global variable Now we can use the “script writing “ the load script is using in the DF & WF Script in always inside a job (or) data flow, WF is a group of DF We can place the script inside DF and corner DF Script is not a reposting object “it is a reusable object”

For in-depth knowledge on SAP HANA, click on below:

• Performance Tuning in SAP HANA
• Security in SAP HANA
• Organizing system Landscapes in SAP Hana
• Analytical Privileges in SAP HANA
• SAP HANA Views