Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

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


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


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 (delta)


dp



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020