Delta is running currently. need to do full load to different DSO

[former_member604676]

Hi,

For DS,0CO_OM_CCA_9, A delta load is already up and running in our BW 7.0 production system for the past couple of years.

Now the requirement is to create a new DSO using the same datasource ( with different routines and logic).

Can you please advise how to load data to new DSO, without disturbing the existing Delta pointer ?

Do i need use Repair full request ?  What is the approach to be followed so that from the source system, both DSOs are loading without any issue ?

Thanks in advance

[former_member186053 · Accepted solution]

Hi Rodney,

I assume you need to get historical data to this new DSO, so you have to go with repair full request option as it would not allow you to go with new init until you have to delete the existing delta init. Once repair full request is done you can create a new DTP to load the daily delta data from PSA into new DSO flow. To be sure give a try in Dev system before doing it in Prod.

Regards,

Vengal.

[RamanKorrapati]

Hi Rodney,

This is your new data flow - Data source--->PSA--->DSO.

Assumed as PSA have historic data then no issues. its easy to handle.

Create new dso, transforamtions between data source and DSO.

Later create delta dtp and load data. Frist dtp, it will load full data+init.

Next what ever new request comes at PSA, that will be loaded to DSO as delta request.

if There is no old data  at PSA then you need to load historic data from source to PSA thru repair full request. from PSA to DSO you can load as stated above.

Note: if you have huge data then please try to load data to DSO with small chunks and activate them once you load. If you load huge data at once to dso then activatation may raise dump issues/failures(due to bad/invalid data, its time consume activity)

Thanks

[former_member604676]

Thanks. There is no data in PSA. The only option is do repair full load, without disturbing the existing delta.

[former_member194898]

Hi,

First load data to PSA then to each object like dso or cube.

Create data flow like this (picture below).

Regards, Leszek