Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 21 Mar 2003 @ 18:42:38 GMT


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


Subj:   Re: Fastload and default values
 
From:   McBride, Michael

Yes, that is correct. One way to do this is to fastload two separate tables, one with "default" value and the other with not null, non- default (actual) values. Then merge the two tables with an optimized insert/select (table merge) into final target table.

One other possibility is to convert a null input value to the tables default value in the VALUES input stream using the COALESCE function...

Insert into TableA (col1,col2, col3)
values (
:in_col1
, coalesce (:in_col2, "default_value")
, :in_col3
);



     
  <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: 27 Dec 2016