Archives of the TeradataForum

Message Posted: Wed, 25 Apr 2007 @ 11:21:39 GMT

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

Bearing in mind I don't understand you environment but I would create a copy of the Production table in Production Ins/Sel from Work into the copy ( however long that takes), rename the original as _old , repoint the view(s) to the _old table, rename the _new table , collect stats / add indexes etc then repoint the view to the new table - should be seamless to the end users.

And as suggested if this is a regular occurrence I would look to fixing the problems elsewhere( before loading, during the etl or in place (delta)

dp

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