Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 05 Jul 2004 @ 09:43:37 GMT


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


Subj:   Order of Records in Source file for MLOAD
 
From:   Anomy Anom

<-- Anonymously Posted: Monday, July 05, 2004 05:36 -->

Hi,

If a source file has more than one record with same primary index (unique) value, what happens when an UPSERT MLOAD is run to load this file into a teradata table (with unique primary index)?.

Will the first record (as per the sequence in the file) be INSERTED (assuming the table did not have the record before) and will the second record update the just INSERTED record ? If yes, where does this UPDATE happen; in the WORK table before applying to target table or while applying to the target table ?


Thanks and Regards



     
  <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