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

Step 1. Create a FastExport Connection

Step 1. Create a FastExport Connection

Create a FastExport connection in the Workflow Manager. If you edit a FastExport connection, all sessions using the connection use the updated connection.
To create a FastExport connection:
  1. Click Connections > Application in the Workflow Manager.
    The Connection Browser dialog box appears.
  2. Click New.
  3. Select a Teradata FastExport connection and click OK.
  4. Enter a name for the FastExport connection.
  5. Enter the database user name.
  6. Enter the password for the database user name or click Use Parameter in Password to use the session parameter $Param
    Name
    for the database password.
    If you enable Use Parameter in Password, define the password in the workflow or session parameter file and encrypt it by using the
    pmpasswd
    CRYPT_DATA option.
  7. Select the code page that FastExport uses to read Teradata sources.
    FastExport uses the fexpcodepagemapfile.dat file to map the code page name to the Teradata character set that FastExport supports. Verify that the file includes the code page and that the assigned character set is enabled on the Teradata database.
  8. Enter the FastExport attributes and click OK.
The following table describes the attributes that you configure for a Teradata FastExport connection:
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.


Updated August 27, 2020