cancel
Showing results for 
Search instead for 
Did you mean: 

Enabling delta in Data services while extracting from BW

0 Kudos

Hi Experts,

We have the requirement to enable delta mechanism in DS while extracting data from SAP BW active data tables and loading into DS Staging area Oracle db.

Ex:

Day 1 - Active data table in BW

Sales order NumberSales order ItemMaterialCreated DateAmountQuantity
0000048635100JS-NETDIR07-NOV-131020
0000048635101SVC-JS-NETDIR-1Y07-NOV-132030
0000049272100CHAS-BP-MX480-S08-DEC-1331

First day when we run the DS load we got all the 3 records from BW to DS Staging.

Day 2 - Active data table in BW, we have few records modified and added as highlighted below in red and blue.

Sales order NumberSales order ItemMaterialCreated DateAmountQuantity
0000048635100JS-NETDIR07-NOV-131020
0000048635101SVC-JS-NETDIR-1Y07-NOV-133090
0000049272100CHAS-BP-MX480-S08-DEC-1356
00000003431045W454120-AUG-1357
000000042830DR74X27-AUG-13323
000000093810CHAS-BP-MX480-S01-OCT-131034

So when I run delta on 2nd day only it should load the 5 records i.e. changed records (2 Highlighted in Red) and newly added records(3 Highlighted in Blue)

Please suggest the ways how the delta extraction can be enabled in DS while extracting from SAP BW.

Thanks & Regards,

Raju.

View Entire Topic
0 Kudos

Hi All,

Thanks for all your valuable suggestions, we are still in the discussion of trying out various options.

Will update once we finalize on the approach.

Thanks & Regards,

Raju.