Was this helpful?
Teradata (Fastload)
The integration platform reads and writes Teradata Fast Load files. This connector produces unique Teradata Bulk Load format files. Teradata is an NCR data warehouse management product.
Teradata FastLoad Utility
The Teradata FastLoad Utility moves data into empty tables in the Teradata RDBMS. This batch mode product does a high-speed initial load of tables into the database. The source for FastLoad can be from a flat file or an access module provided by NCR or an end user.
See the NCR website for more information on Teradata.
Connector-Specific Notes
Teradata decimal data types do not have precision and decimal places. The integration platform only displays the size (4 bytes). The decimal data type maps to the text data type. This is because the Teradata decimal data type has a varied length (1, 2, 4, 6, 8). It is impossible to map it into a decimal data type (fixed length=4). Therefore, Teradata (Fastload) creates a fixed decimal (two places) in both Source and Target.
Connector Parts
Connector parts are the fields you configure to connect with a data source or target.
The settings that are available depend on the connector you select.
For a list of all parts for source connectors, see Specifying Connector, Parts, and Properties.
For a list of all parts for target connectors, see Specifying Connector, Parts, and Properties.
Property Options
You can specify the following source (S) and target (T) properties:
Property
S/T
Description
RecordSeparator
S/T
LF(000A) – default
CR(000D)
JobScript
T
(Optional) Enter a text file name to create a flat file that can be uploaded to a Teradata data warehouse database. The integratin platform automatically creates a text file that contains a script that the Teradata FastLoad Utility can understand, making it faster than typing in the script by hand. You must modify the Database ID, User name and Password to execute the script.
FastLoadTable: (Optional) Enter a table name here. If you do not, a default name is provided, called Table1.
FastLoadTable
T
Enter a table name here. If you do not, a default name is provided, called Table1.
Supported Data Types
If you want to set different record delimiters for your target records, see Record Delimiter under property options. For Teradata (Fastload) data, the following types are available:
Byte
ByteInt
Char
Date
Decimal
Float
Integer
Long VarChar
Numeric
Real
SmallInt
Time
Timestamp
Varbyte
VarChar
Length
These are field lengths in your data. If you need to change field lengths, reset them in the schema.
Note:  A field length shorter than the default may truncate data.
Last modified date: 02/09/2024