Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 31 Oct 2005 @ 18:30:44 GMT


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


Subj:   Re: Fastexport, multiload, nulls and blanks
 
From:   Prescott, Kyle R

If you are using a Teradata utility to load the data from FastExport, use the MODE INDICATOR (instead of RECORD) on the export and the MLOAD .LAYOUT should also use INDICATOR.

This allows the null indicator presence bits to be placed in front of the data record on the export allows the load utilities to automatically handle the null processing. You won't need to utilize case statements or even NULLIF's.


Kyle Prescott
UnumProvident



     
  <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