Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 30 Jul 2004 @ 17:49:04 GMT


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


Subj:   Re: Impact of changing primary index on mload upsert
 
From:   Michael Larkins

I have never attempted to change the data in a PI column using MultiLoad. However, I have heard (and believe) that it will not work. I say this with a fairly high degree of certainty.

Why - because Multiload in the IMPORT task will only do one AMP operations with the data and SQL that exists on it. When you change the data value of a PI, the likelihood of that row needing to move is high. Therefore, Multiload will refuse to do the operation because it is not a one AMP operation.

How to avoid - don't change the PI data

Thats my take on the situation. Now, we can hear from people who have actually tried it.


Michael Larkins
Certified Teradata Master



     
  <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: 15 Jun 2023