on 06-18-2015 6:35 PM
Hello Experts,
if Data Target is infocube.
Is it a good practice to delete earlier PSA request & then trigger infopackage to load new request in PSA for every run ?
delete infocube contents before every run & trigger DTP load,irrespective of DTP delta / full update.
just to avoid data duplication in cubes.
if Data Target is Master data infoobject
This is no possibility for duplication of records in infoobject, so deleting earlier PSA request is not necessary.
Please clarify this understanding.
Thanx.
Hi Ram,
Normally PSA data should be deleted.
there should not be an issue in deleting psa requests of full loads.
For delta it is normal practice to keep atleast 1 week or 2 before deletion.
You have to analyse the type data being loaded and think the worst case of issues popping up if PSA is deleted and then decide the best retention time.
For certain scenarios like inventory loads , its better to retain for little longer.
coming to cube, yes its good to delete the old requests, if not needed. This has to be decided only on the specific cases. for example we have actual and plan data being loaded daily. Older requests of plan data can be deleted. so have to decide based on the the requirements.
best regards,
sudhir
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ram,
As mentioned - the question is not very clear....
there are pros and cons to keeping PSA..
Why should you keep PSA
1. If you delete a request in the cube , you can reconstruct it if the PSA is available
Why you should not keep PSA
1. PSA is data as it was at the time of extraction - you will end up with a lot of additional space taken up if you do not delete PSA
2. Possibility of data mismatch - if someone triggers a full DTP when they should be triggering a delta - it will lead to data duplication
A rule of thumb is :
If you can get the data back from the source system any time ( full loads from ECC / flat file etc ) - do not keep PSA
If you will have a need to reconcile historical data which cannot be got easily from the source - keep PSA - here also institute a time limit to keep PSA data for - like clear requests older than 40 days or something like that
The question of whether you want to keep PSA or not and for how long you want to Keep it is a function of the following :
1. Nature of data ( transaction / time dependent / not easily recoverable )
2. Target being loaded to
3. Space available
Hope this helps....
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ram,
Kindly, frame your query for our better understanding so that we can answer more better.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.