Hello,
We are having a huge ODS with nearby 800 millions records. We are
planning to archive this ODS as soon as possible. We've begun to
archive the ODS month by month, but as you can imagine the write/delete
(SARA) process is very slow (full table scan).
We have done a test with 7 million records to delete :
It took us :
2 hours : SARA Write process (create archive files)
12 hours : SARA Delete process (execute delete program)
Our ODS contains 45 millions records per month, we can launch the archive jobs in our production environnement only during the week end.
It will take us months
to complete our archiving scenario.
How can we improve the archiving process ?
We don't really need the data that are beyond 18 months, is there a
better way to delete those data : selective deletion ?
Thank you in advance for your answers.
Business Information Warehouse 3.0B
Message was edited by:
ramos alexandro