Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 15 Mar 2012 @ 19:47:45 GMT


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


Subj:   Re: Subtables for FLOAD
 
From:   Dave Wellman

Hi,

I think you are actually referring to the work table that Multiload uses for each target table (in Teradata the term "sub-tables" has a specific meaning which I don't believe is what you are referring to).

Fastload doesn't use a work table because it can only INSERT rows into an empty table, therefore there is no requirement for holding a copy of the input data (which is what goes into the Multiload work table) before applying changes to the target table.

Hope that helps.


Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)



     
  <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