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

Teradata® FastLoad Reference

Product
FastLoad
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
ije1544831946874.ditamap
dita:ditavalPath
obe1474387269547.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 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)