|
|
Archives of the TeradataForum
Message Posted: Mon, 24 May 2010 @ 18:51:56 GMT
Subj: | | Reducing the retention |
|
From: | | Anomy Anom |
<-- Anonymously Posted: Monday, May 24, 2010 11:12 -->
Hi,
We have aggregate tables with the history data of 10 years. To save the space, it has been decided to reduce the retention to 5 years. However,
when the requirement for accesing the old data comes in we would have to restore the data that has been archived immediately.
Can somebody please help & suggest like what should be the strategy followed for this.
Thanks
| |