How many PSA keep in the case of FULL update?

[Former Member]

Hi Guru,

I am wondering how many PSA do I have to keep in the case of FULL update?

1 - Concerning the Master Data process chains in FULL mode is it necessary to keep the old PSA?

2 - Concerning the Transactional Data pc in FULL mode (with or w/o selection criteria) is it necessary to keep the old PSA too?

Usually for the delta pc I keep 45 days of PSA.

Is there a best practices document?

Samuel

[Former Member · Accepted solution]

Hi Samuel,

I am not sure of any best practice document for this. But It should be sufficient to keep Full load PSA for 1 day.

In our project, we keep MD Full load PSA for 1 day and TD Full load PSA for 7 days.

Regards

Hemant Khemani

[Former Member · Accepted solution]

Hi Hemant,

For my curiosity,

For the MD Full load, do you manage FULL or DELTA DTP?

For the TD Full load, I think you delete the entire content of your cubes before. If you keep 7 days of PSA you mandatory use DELTA DTP, don't you? Else you encounter problem to process the last PSA...

When we have choice to use DELTA or FULL DTP, is there a best one?

Regards

Samuel

[Former Member · Accepted solution]

1.Assume you are loading full loads till PSA - from there delta DTP to MD

REQ1 - 10000 records and DELTA DTP - 10000 (DTP will consider only REQ1)

REQ2 - 11000 records and DELTA DTP - 11000(it will consider only REQ2 not req1)

REQ3 - 12000 records and DELTA DTP - 12000(it will consider only REQ3 not req1, 2 )

REQ4 - 15000 records and DELTA DTP - 15000(it will consider only REQ4 not req1, 2, 3)

PSA size is growing and delta dtp will consider only newly loaded request from PSA that updates to MD(overwrite existing records as u know)

2.You are deleting PSA request before the load begins(assume) in process chain

day1

REQ1 - 10000 records and DELTA DTP - 10000 (DTP will consider only REQ1)

day2 - it will delete REQ1 and loads

REQ11 - 11000 records and DELTA DTP - 11000(it will load eveything from PSA since there is only one req

It's up to how you plan to delete PSA requests .. could be daily/weekly/monthly ... Create seperate PC and add only one process PSA deletion and add all the full load IPs(MD related) and schedule as you want(when the system resources are free!)

For the TD Full load

I would prefer to delete entire contents from Cube and PSA as well before IP starts... of course you can keep PSA for seven days .. but does it makes sense for me? what is the use of having requests in PSA for 7 days?? however I get incremental data (full loads) everyday/weekly..etc

If you keep 7 days of PSA you mandatory use DELTA DTP, don't you?

Yes I will make the dtp to delta

[Former Member]

You can delete PSA data older than 1 week.

-Vikram

[FCI]

Hello Samuel,

Usually, I try to keep things simple : same rules for all PSA (full, delta, change log etc.) otherwise deletion tasks begins to become hard to maintain and some PSA may be forgotten in these tasks.

But I assume it depends on the size of your full PSA and of your disk...

Regards,

Fred

[Former Member]

1 - Concerning the Master Data process chains in FULL mode is it necessary to keep the old PSA? NO

2 - Concerning the Transactional Data pc in FULL mode (with or w/o selection criteria) is it necessary to keep the old PSA too? NO

For Full Loads I would prefer to delete PSA before IP begins in the Process chain

START - delete PSA - load IP to target

This way you will always have one PSA request .. if you want to reload data for any reasons

[Former Member]

Hi Srinivas,

I have for you the same questions as Hemant.

Regards,

Samuel