Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 06 Oct 2011 @ 08:47:01 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Fastload options
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, October 05, 2011 23:44 -->

Hi All,

I'd like to know whether I could FASTLOAD a text file into Teradata, but skipping the header and trailer records (only load the Detail records).

     D|20110928 000000|0|21|0|774|173|98|460|43
     D|20110928 000000|0|0|0|373|315|48|10|0
     D|20110928 000000|140|60|0|2433|69|2147|185|32
     D|20110928 000000|89|0|0|321|189|25|107|0
     D|20110929 000000|84|0|0|547|0|452|95|0
     D|20110929 000000|4213|1691|13|8309|198|2147|4262|1702
     D|20110929 000000|421|0|0|2224|0|1763|461|0
     D|20110929 000000|155|292|0|4823|202|3807|167|647
     D|20110929 000000|498|0|0|2301|755|1015|531|0
     D|20110930 000000|5712|1157|111|9644|456|984|5861|2343

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023