User Guide : Map Connectors : Source and Target Map Connectors : Teradata (Fastload)
 
Share this page                  
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.
Property Options
You can set the following source (S) and target (T) properties.
Property
S/T
Description
RecordSeparator
ST
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.
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.