Skip to Content
0
Former Member
Dec 12, 2006 at 08:23 AM

How to improve ODS archiving performance ?

78 Views

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