cancel
Showing results for 
Search instead for 
Did you mean: 

Update from PSA Process

Former Member
0 Kudos

Hello,

i have a problem with the "Update from PSA" Process in a Process Chain.

I am loading data from ODS A into ODS B.

The data is loaded via Delta Update into the PSA and should be then updated via a full repair request into ODS B.

(It is not possible to load the data via delta process into ODS B, because I deleted all data from the ODS and rebuilted it with full repair requests.)

It is manually possible to do this procedure, but it was not possible for me to figure out a way how to manage the procedure in a process chain.

Would be great if someone could help me.

View Entire Topic
Former Member
0 Kudos

If you do not load any other data providers from ODS A, you can repeat the whole process. You just have to delete the existing delta initialization in your init infopackage. After that you can do a new initialization.

Former Member
0 Kudos

Thank you for all the responses.

The Problem is that the data is updated also into other data targets (two other ODS objects).

There the Delta Process is still working and I don't want to risk to cancel the Delta Process there.

Former Member
0 Kudos

Oliver

Is ur load from ODS1 -> PSA is delta ?

Former Member
0 Kudos

Yes it is.

The load is from ODS A like i used to call it loaded via delta process into the psa.

Then it should be updated into ODS B via full repair request and via delta request into the other targets (ODS C and D).

Former Member
0 Kudos

Hi Oliver,

Here is a suggestion.

1> Create a new data source on the view created from the active table of the source ODS A.

2> Use that DataSource to do a full update into ODS B

3> This will not affect the Delta mechanism of loads into ODS C & D.

Regards,

Sree

Former Member
0 Kudos

Oliver

Iam not sure if this is possible.

Only thing flash my mind is to have 2 infopackge

one for full upload to ODS B and another one for delta upload to other ODS

Rohini

Former Member
0 Kudos

Hi Rohini,

<i>one for full upload to ODS B and another one for delta upload to other ODS</i>

This is not possible as the Delta Information is stored at DS level. You will get a error/warning when you try to do this.

Regards,

Sree

Former Member
0 Kudos

Sree,

Thanks Sree for correcting. I was not very sure about it. But this way doubts are clear.

Thanks,

Rohini

Former Member
0 Kudos

Thank you Sree for your help.

I will try your suggestion.

Former Member
0 Kudos

U R Welcome (Oliver & Rohini)!

Good luck!

Regards,

Sree