Table of Contents

Search

  1. Preface
  2. Understanding Pipeline Partitioning
  3. Partition Points
  4. Partition Types
  5. Pushdown Optimization
  6. Pushdown Optimization and Transformations
  7. Real-time Processing
  8. Commit Points
  9. Row Error Logging
  10. Workflow Recovery
  11. Stopping and Aborting
  12. Concurrent Workflows
  13. Grid Processing
  14. Load Balancer
  15. Workflow Variables
  16. Parameters and Variables in Sessions
  17. Parameter Files
  18. FastExport
  19. External Loading
  20. FTP
  21. Session Caches
  22. Incremental Aggregation
  23. Session Log Interface
  24. Understanding Buffer Memory
  25. High Precision Data

Advanced Workflow Guide

Advanced Workflow Guide

Configuring Teradata FastLoad External Loader Attributes

Configuring Teradata FastLoad External Loader Attributes

Use the following guidelines when you work with the FastLoad external loader:
  • Each FastLoad job loads data to one Teradata database table. If you want to load data to multiple tables using FastLoad, you must create multiple FastLoad jobs.
  • For a session with multiple partitions, use the round-robin partition type to route data to a single target file.
  • The target table must be empty with no defined secondary indexes.
  • FastLoad does not load duplicate rows from the output file to the target table in the Teradata database if the target table has a primary key.
  • If you load date values to the target table, you must configure the date format for the column in the target table in the format YYYY-MM-DD.
  • You cannot use FastLoad to load binary data.
  • You can use comma (,), tab (\t), and pipe ( | ) as delimiters.
To configure attributes for the Teradata FastLoad external loader, click Connections > Loader, select the Type, and click Edit.
The following table shows the attributes that you configure for the Teradata FastLoad external loader:
Attribute
Default Value
Description
TDPID
n/a
Teradata database ID.
Database Name
n/a
Database name.
Error Limit
1,000,000
Maximum number of rows that FastLoad rejects before it stops loading data to the database table.
Checkpoint
0
Number of rows transmitted to the Teradata database between checkpoints. If processing stops while a FastLoad job is running, you can restart the job at the most recent checkpoint.
If you enter 0, FastLoad does not perform checkpoint operations.
Tenacity
4
Number of hours FastLoad tries to log in to the required FastLoad sessions when the maximum number of load jobs are already running on the Teradata database. When FastLoad tries to log in to a new session, and the Teradata database indicates that the maximum number of load sessions is already running, FastLoad logs off all new sessions that were logged in, delays for the number of minutes specified in the Sleep attribute, and then retries the login. FastLoad keeps trying until it logs in for the required number of sessions or exceeds the number of hours specified in the Tenacity attribute.
Drop Error Tables
Enabled
Drops the FastLoad error tables before beginning the next session. FastLoad will not run if non-empty error tables exist from a prior job.
Select this option to drop the tables, or clear it to keep them.
External Loader Executable
fastload
Name and optional file path of the Teradata external loader executable. If the external loader executable directory is not in the system path, you must enter the full path.
Max Sessions
1
Maximum number of FastLoad sessions per FastLoad job. Max Sessions must be between 1 and the total number of access module processes (AMPs) on the system.
Sleep
6
Number of minutes FastLoad pauses before retrying a login. FastLoad tries until the login succeeds or the number of hours specified in the Tenacity attribute elapses.
Truncate Target Table
Disabled
Truncates the target database table before beginning the FastLoad job. FastLoad cannot load data to non-empty tables.
Is Staged
Disabled
Method of loading data. Select Is Staged to load data to a flat file staging area before loading to the database. Otherwise, the data is loaded to the database using a named pipe.
Error Database
n/a
Error database name. Use this attribute to override the default error database name. If you do not specify a database name, the Integration Service uses the target table database.
The following table shows the attributes that you configure when you override the Teradata FastLoad external loader connection object in the session properties:
Attribute
Default Value
Description
Error Table 1
n/a
Table name for the first error table overrides the default error table name. If you do not specify an error table name, the Integration Service uses ET_<target_table_name>.
Error Table 2
n/a
Table name for the second error table overrides the default error table name. If you do not specify an error table name, the Integration Service uses UV_<target_table_name>.
Control File Content Override
n/a
Control file text. Use this attribute to override the control file the Integration Service uses when it loads to Teradata.


Updated June 25, 2020