Data Conversion Capabilities - MultiLoad

Teradata® MultiLoad Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
MultiLoad
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2024-03-18
dita:mapPath
lji1691576359330.ditamap
dita:ditavalPath
kju1619195148891.ditaval
dita:id
sga1478609868891
Product Category
Teradata Tools and Utilities

Teradata MultiLoad can redefine the data type specification of numeric, character, and date input data so it matches the type specification of its destination column in the Teradata MultiLoad table on the database.

For example, if an input field with numeric type data is targeted for a column with a character data type specification, Teradata MultiLoad can change the input data specification to character before inserting it into the table.

The types of data conversions can be specified are:

  • Numeric-to-numeric (for example integer-to-decimal)
  • Character-to-numeric
  • Character-to-date
  • Date-to-character
Redundant conversions, such as integer-to-integer, are legal and necessary to support the zoned decimal format. For more information about the zoned decimal format, data types, and data conversions, see Teradata Vantage™ - Data Types and Literals, B035-1143.