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 fields that are available depend on the connector you select.
For a list of all parts for source connectors, see
Specifying Source Connector, Parts, and Properties.
For a list of all parts for target connectors, see
Specifying Target Connector, Parts, and Properties.
Property Options
You can specify the following source (S) and target (T) properties:
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: 10/22/2024