Input Data Formats | Teradata FastLoad - 17.10 - Input Data Formats - FastLoad

Teradata® FastLoad Reference

Product
FastLoad
Release Number
17.10
Published
June 2021
Last Update
2021-07-01
Content Type
Programming Reference
Publication ID
B035-2411-061K
Language
English (United States)

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 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 workstation-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)