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

[Former Member]

Oliver

Your uploading ODS B from ODS A?

If yes, then you cannt upload the data via PSA.

Please correct me if iam wrong in understanding.

Mention step by step how your uploading.

Regards,

Rohini

[Former Member]

The Upload looks like this:

ODS A ---> PSA ---> ODS B

From ODS A into PSA: Delta Update

From PSA into ODS B: Full Repair Update

The problem is, if i use the "Update from PSA" Process in the Process Chain it uses a Delta Process,

but I need a Full Repair Process.

The reason why I need a full repair request is that I deleted all data from ODS B, including the Initialize process and rebuilted it with full reqair requests.

Now if i am loading delta updates, i can not activate the request (in ODS B), because of the missing init request.

It is also not possible to load a full update request, because I also get a error message, when I try to activate the data. So a full repair requst is my only solution.

The easiest way would be to reconstruct the old initialize request and the following deltas, but

it would take to much time.

[Former Member]

Hi Oliver,

After doing Full repair requests into ODS B, you can still continue with you Delta updates from A -> B by simply doing a Init Without Data transfer from A-> B which will help resume your Delta updates.

(If I understood correct, now you have all data from A into B and in future want to continue with the Delta updates into B from A forany change/addition in A)

Also, make sure you have updated B thru <b>Repair</b> requests and not just Full loads. Take a look at OSS note 689964 if you want to know more details on this.

Regards,

Sree

Regards,

Sree