Archives of the TeradataForum
Message Posted: Mon, 13 Feb 2006 @ 23:55:58 GMT
| Subj: || || Question on Strategy |
| From: || || Kambhoji, Naveen Ram Prasanna |
We have a requirement to limit the database size by 500GB since the IT dept is able to allocate only this much space to our data mart. We have
to design an ETL process that calculates the size of the incremental load and the size of the existing load, the load should happen only when the
total size is < 500 GB , If the size exceeds by 500 GB then the ETL Process should be able to remove the old data so that it can accomodate the
data that is coming in. Is there any best approach for this? Are there any successful stories ?
Thanks for your time and responses.