Archives of the TeradataForum
Message Posted: Thu, 06 Oct 2011 @ 08:47:01 GMT
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).
H|05/10/2011
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
T|10
|