Performance Considerations - MultiLoad

Teradata® MultiLoad Reference

Product
MultiLoad
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
aim1544831946660.ditamap
dita:ditavalPath
gyk1507317446489.ditaval
dita:id
B035-2409
lifecycle
previous
Product Category
Teradata Tools and Utilities

The majority of client processing during a Teradata MultiLoad job occurs when it is processing its input rows. The most efficient means of sending the row to the database would be a bulk move of the input row to the output row.

However, there are many cases where fields need to be evaluated and field data may need to be individually moved from the input to the output row. Note, however, that performance is affected whenever a field needs to be evaluated or individually moved.

The need for moving individual field data from the input to the output row occurs for any of the following scenarios:
  • DROP syntax on FIELD statements
  • FILLER fields
  • Concatenated fields
  • Complex layout (first field is variable-length field, redefinition of field positions)

Variable length fields, NULLIF in the layout, and APPLY WHERE clauses might require additional CPU consumption.