Table of Contents

Search

  1. Preface
  2. Introduction to TDM Administration
  3. User and Role Administration
  4. Security Administration
  5. System Preferences
  6. TDM Server Administration
  7. Connections
  8. Pass Phrases
  9. Dictionaries
  10. User-Defined Datatypes

Teradata FastLoad Connections

Teradata FastLoad Connections

You can create a Teradata FastLoad connection in Test Data Manager to perform data subset and data masking operations.
The following table describes the database connection properties to access Teradata through FastLoad:
Property
Description
Name
Required. Name of the connection. The name is not case sensitive and must be unique within the domain. It cannot exceed 128 characters, start with a number, contain spaces, or contain the following special characters:
~ ` ! $ % ^ & * ( ) - + = { [ } ] | \ : ; " ' < , > . ? /
Connection Type
Required. The connection type. Select Teradata FastLoad.
Description
The description of the connection. The description cannot exceed 255 characters.
User Name
Required. The database user name.
Use Parameter in Password
Indicates the password for the database user name is a session parameter. $Param
Name
. Define the password in the workflow or session parameter file, and encrypt it using the
pmpasswd
CRYPT_DATA option.
Used for data subset and data masking operations. Default is disabled.
Password
Required. The password for the database user name.
Owner
The owner of the connection. Default is the user who creates the connection. You can change the owner of the connection.
Code Page
The code page that the Integration Service uses to extract data from the source database.
Database Name
The name of the Teradata database you want to connect to. The Integration Service generates the SQL statement using the database name as a prefix to the table name.
TDPID
Teradata database ID.
Tenacity
Number of hours that 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.
Default is 4.
Max Sessions
Maximum number of FastLoad sessions per FastLoad job. Max Sessions must be between one and the total number of access module processes (AMPs) on your system.
Default is 1.
Sleep
Number of minutes FastLoad pauses before retrying a login. FastLoad attempts a login until the login succeeds or the Tenacity hours elapse.
Default is 6.
Error Limit
Maximum number of rows that FastLoad rejects before it stops loading data to the database table.
Default is 1,000,000.
Check Point
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.
Default is 0. If you enter 0, FastLoad does not perform checkpoint operations.
Drop Error Tables
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 the tables.
External Loader Executable
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.
Is Staged
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
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.
Truncate Target Table
Truncates the target database table before beginning the FastLoad job. FastLoad cannot load data to non-empty tables.