Full/Delta/Initialize delta update methods

Introduction

Update method is used to get the updated data coming from the source system to BI system at Info package level. We can set update methods in the update tab of the info package.

The update methods in the info package are:

1. Full Update

2. Delta Update

3. Initialize Delta Process

    (I) Initialize with data transfer

    (II) Initialize without data transfer

    (III) Early Delta Initialization

1.Full Update

Full update extracts the full data from source system to PSA in BI7 every time. 

2. Delta Update

Delta update extracts delta records only from the BW delta queue in the source system to BI system.

We must initialize the delta in order to get delta records, otherwise it is not possible to load delta records.

The following are the 4 delta types for the data source in the system.

F: Flat file provides the delta

E: Extractor determines the delta, Ex: LIS, COPA

D: Application determines the delta, Ex: LO, FI-AR/AP

A: Use ALE change log delta

Note: We can know the delta properties from ROOSOURCE table in the source system with SE16 transaction code.

3.Initialize Delta Process

To get the delta records, one must initialize the delta process. While initializing the delta process, the system will generate a flag: Initialize option for the source system in (scheduler menu of info package) BI and BW delta queue per the data source in the source system (RSA7). This enables the time stamp mechanism.

Initialize with data transfer

If you select this option, It extracts the init data from source system to BI system and allows delta functionality.

Steps for initialize with data transfer

Lock the users in the source system 

Delete the contents of the setup tables for the specific application component in source system(T code: LBWG). 

Fill the setup tables (SBIW or OLI*BW, use 1,2,3...in place of * according to the application ). 

Run the info package with initialize with data transfer. 

unlock the users in the system 

Note: This is very time consuming process, because we need to lock the users until data reaches to the BI system.This effects the client business.

Initialize without data transfer

In some cases, init is successful but someone has deleted the init flag. In order to set the flag again to perform the delta load without disturbing the data, we execute IP with this option.

Steps for initialize without data transfer

Lock the users in the source system 

Delete the setup tables content for the specific application component. 

Fill the setup tables 

Run the IP with the option: Initialize without data transfer. 

Unlock the users in the source system 

Load data to BI system using repair full request info package 

Note: In this method, after data is loaded to setup tables we can unlock the users in source system. this is better option than initialize with data transfer option.

Early Delta Initialization

In this option, we can do the delta initialization before filling the setup tables.So that users can post the documents when we are filling the setup tables.We will get the posted records in the next delta run

Steps for early delta initialization

Run the Info package with early delta initialization option.This will enable the BW delta queue and setup the time stamp for delta in the source system. 

Delete the setup tables for the application component 

Fill the setup tables 

Load the setup table data using repair full request (scheduler menu option of info package) info package 

How to check whether the data source supports early delta initialization or not?

Go to SE16 in ECC, give table name: ROOSOURCE and enter 

In the next screen give data source like 2lis_02_sdr(purchase document header data source) name and enter 

if field ZDD_ABLE has a value 'X', then the data source supports early delta initialization 

If the filed has space, then the data source does not support early delta initialization.