PowerCenter
- PowerCenter 10.4.1
- All Products
Attribute
| Default Value
| Description
|
---|---|---|
TDPID
| n/a
| Teradata database ID.
|
Tenacity
| 4
| Number of hours that FastExport tries to log on to the Teradata database. When FastExport tries to log on but the maximum number of Teradata sessions is already running, FastExport waits for the amount of time defined by the SLEEP option. After the SLEEP time, FastExport tries to log on to the Teradata Database again.
FastExport repeats this process until it has either logged on for the required number of sessions or exceeded the TENACITY hours time period.
|
Max Sessions
| 1
| Maximum number of FastExport sessions per FastExport job. Max Sessions must be between 1 and the total number of access module processes (AMPs) on your system.
|
Sleep
| 6
| Number of minutes FastExport pauses before retrying a login. FastExport attempts a login until the login succeeds or the Tenacity hours elapse.
|
Block Size
| 64000
| Maximum block size to use for the exported data.
|
Data Encryption
| Disabled
| Enables data encryption for FastExport. You can use data encryption with the version 8 Teradata client.
|
Logtable Name
| FE_<source_table_name>
| Restart log table name. The FastExport utility uses the information in the restart log table to restart jobs that halt because of a Teradata database or client system failure. Each FastExport job should use a separate logtable. If you specify a table that does not exist, the FastExport utility creates the table and uses it as the restart log.
PowerCenter does not support restarting FastExport, but if you stage the output, you can restart FastExport manually.
|
Executable Name
| fexp
| Teradata command used to read the source data. Use the default value.
|
Database Name
| n/a
| 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.
|