|
|
Archives of the TeradataForum
Message Posted: Mon, 12 Feb 2001 @ 11:07:22 GMT
Subj: | | Data Warehouse's Data |
|
From: | | Amer Baig |
Hello All
I need some comments from all of you, regarding keeping data in warehouse. Problem: We are in process of designing and implementing a
Telecom Data Warehouse (Teradata). What theory and best practices say about keeping data in data warehouse? Means for how much duration of
data we should keep in warehouse's database. I mean data for last 2/3 years should be in database??? Or data can not be deleted from data
warehouse. Will data remain in data warehouse for the entire life of data warehouse? Should the data be refreshed from its data sources as
per company policy, means delete old data and insert new data. Are there any suggestions for such company policy.
Please help me out.
Regards
Amer
| |