Archives of the TeradataForum
Message Posted: Mon, 12 Feb 2001 @ 15:09:08 GMT
As others have mentioned the main criteria for how long you need to keep data is the requirement of your business. You need to inform the business of cost and performance ramifications. This will influence the business to cost-justify some housekeeping, such as keep detailed data for 'x' months and maybe summary data for 'y' months.
The next decision is how to housekeep - do you delete old rows or do you save them on some other medium for potential future access?
If your business is reluctant to totally throw away the data then you can explore approachs to save old data along with corresponding table definition (nb. the live table definition is liable to change subsequently):
1) Load data-to-be-deleted onto a separate table and then archive that table and data dictionary definition off to tape....can be copied back sometime in the future if so required.
2) Save the output from BTEC 'Show Table' and from FastExport (default format)....can be restored by creating a new table and running FastLoad (default format).
Obviously in both cases you also delete from the main table. Also you need to have some documentation strategy to remember where these files are and what time periods they represent. I'm sure there are lots of other techniques for storing housekeeping packages (data plus table definition) and you can weigh up which is the most efficient and, with your business, whether it's worth the effort!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|