Input Data Formats - FastLoad

Teradata FastLoad Reference

Product
FastLoad
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-18
dita:mapPath
tjz1488824663315.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2411
lifecycle
previous
Product Category
Teradata Tools and Utilities

This section covers the data formats supported by Teradata FastLoad as well as those data sets and tapes not supported by the utility.

Input data is the raw data that Teradata FastLoad loads from the client system or workstation to the Teradata Database. The input data can be either formatted, unformatted, variable-length text or of specific file types, depending on the configuration of the client system.

For network-attached configurations, Teradata FastLoad supports the following data formats:
  • Formatted
  • Unformatted
  • Binary
  • Text
  • Variable-length text
For mainframe-attached configurations, Teradata FastLoad supports data sets and tape files with the following record format (RECFM) attributes:
  • Data sets and tape files with the following record format (RECFM) attributes:
    • F (fixed)
    • FB (fixed block)
    • V (variable)
    • VB (variable block)
    • VBS (variable block, spanned)