Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Tue, 24 Apr 2007 @ 15:51:31 GMT


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


Subj:   Re: Converting MULTISET Table to Set Table
 
From:   hock lim

Srinivas,

The table is already in the database, keep it there. Choose a better PI for the set table. Maybe add a PPI and copy only certain partition. Do some queries to filter out dupes before insert.

Also, if you need to do this all the time (copying 800G from temp table to production table), then maybe the etl process can be improved -- maybe a delta process? Less IO and CPU will benefit all users.


Hock



     
  <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