Can we perform Delta Load SAP BW

dataservices sap-erp-bw
1

Hi,

I am extracting data from Oracle and populating into SAP BW? It have High Volume Data( Millions and millions of records).
Could you please suggest what would be the best Delta load type?

Thanks
Kumar

itsvsk :india: (BOB member since 2011-05-04)

2

Your Oracle table, how can you see which row got changed?

Werner Daehn :de: (BOB member since 2004-12-17)

3

Thanks Werner for Quick Response.

I had word with Oracle Team. They said there is time stamp column that identifies the record when inserted/updated.

Thanks
Kumar

itsvsk :india: (BOB member since 2011-05-04)

4

Good, do you read all records with a timestamp > last_successful_loaded_timestamp_minus_one_day (overlap to make sure we don’t lose any data), you load that into BW and inside BW you specify how this loaded data should be merged with the existing data.

Werner Daehn :de: (BOB member since 2004-12-17)

5

Hi Werner,

In my case source and target are same.I donot see any Timestamp. Could you please suggest If we can do table comparision with BW?
I am new to BW environment.What would you sugesst?

Thanks
SK

sudheerdi (BOB member since 2010-11-09)

6

So what is it, is there a timestamp column in the source or not??

No, you cannot use TC against BW as BW itself want’s to do the comparison. So if you really need to go that route you would load all data to BW and then tell BW to figure out the changes.

Werner Daehn :de: (BOB member since 2004-12-17)

7

Hi,

Can i know you extracting the Cube’s Active table or the change log table to perform delta load?

I am stuck here also because the cube it self don’t have timestamp column and i not work with SAP BW before.

Thanks.

josephlcw1985 (BOB member since 2009-12-04)

8

Hello,

Cubes, won’t have Activation /Change Log tables. If you are loading to Cubes and want to have deltas only loaded to Cube, please give Date field as Delta relevant field and also Cube should have the date field to identify the delta fields.

Hope this helps.

Regards,
-S-

nagchandi (BOB member since 2009-06-08)

9

Hi,

I am extract from the DSO objects where each activation is link RSREQDONE table. I using that table as timestamp for delta load.

But there is another problem now which is the Changelog table name is system generate which different in every environment (DEV,SIT,UAT,PROD),
Do anybody here got experience on handling this ?

Thank you.

josephlcw1985 (BOB member since 2009-12-04)