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

Teradata® FastLoad Reference

Product
FastLoad
Release Number
17.10
Published
June 2021
Language
English (United States)
Last Update
2021-07-01
dita:mapPath
ruk1608578422758.ditamap
dita:ditavalPath
vax1619194969834.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)