Archives of the TeradataForum

Message Posted: Mon, 13 Feb 2006 @ 23:55:58 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hello,

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.

	<Prev	Next>		<<First	<Prev	Next>	Last>>