on 10-06-2009 5:02 PM
Hi Gurus,
By mistake I have deleted the data in production from some data targets
all the data is still available in PSA (for 9 months).
This happened in two data targets from two data sources.
No. of records are not even 1 million.
Total no. of request for each PAS is 279.
Is there a way I can load the data in parallel or something.
which can complete the task faster. Right now I am selecting each request
and loading one by one.
Regards
Hi
Are you in BI 7.0?
I am assuming this is a delta, in which case you can load to two targets at a time. Also since you have deleted from the data target you dont have to pull request by request. Just pulling one delta will bring all your requests into the target.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI,
If you are in 3.5 goto reconsturction and select all requet you need to load and go for reconstruction which will reconstruct all request one after the another. No manual intervention necessary.
incase of 7.0 do a init without datatransfer from PSA and give a full update request for 3 months and load all the data which will help you in completing the data load faster.
Hopet this helps for you.
Thanks,
Arun
If the reload will take an extremely long time and you have a recent system backup, the other option is to retrieve the data from the system backup at the Oracle level and import it into your produciton system also at the Oracle level.
We did this once successfully for a single ODS that would have taken weeks to reload. The approach should really only be used in an extreme scenario such as this. If you are interested, respond and I can try to find the directions.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
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.