Update from PSA Process

[Former Member]

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.

[Former Member · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

Oliver

Is ur load from ODS1 -> PSA is delta ?

[Former Member · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

Sree,

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

Thanks,

Rohini

[Former Member · Accepted solution]

Thank you Sree for your help.

I will try your suggestion.

[Former Member · Accepted solution]

U R Welcome (Oliver & Rohini)!

Good luck!

Regards,

Sree