Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 21 Jun 2011 @ 08:29:45 GMT

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

Subj:   Re: Mload Layout consideration
From:   Dieter Noeth

Johnpaul Jepamony wrote:

  In the MLOAD, the work table( WT) tables holds the intermediate data of processing and then loads the data into the permanent table. Here in this case, does the WT table holds all the data of the 200 fields or only the 3 fields of the insert query.  

Only FIELD data is sent to the work table, so just define the remaining 197 fields as FILLERs.


  <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