Archives of the TeradataForum
Message Posted: Wed, 25 Apr 2007 @ 11:21:39 GMT
| Subj: || || Re: Converting MULTISET Table to Set Table |
| From: || || David Pracy |
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