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 3. Change the Source Connection

Step 3. Change the Source Connection

To use FastExport in the session, change the Teradata source connection to a Teradata FastExport connection. You can override some session attributes.
The following table describes the session attributes you can change for FastExport:
Attribute
Default Value
Precision
Is Staged
Disabled
If enabled, FastExport writes data to a stage file. Otherwise, FastExport writes data to a named pipe.
Fractional seconds precision
0
The precision for fractional seconds following the decimal point in a timestamp. You can enter 0 to 6. For example, a timestamp with a precision of 6 is 'hh:mi:ss.ss.ss.ss.' The fractional seconds precision must match the setting in the Teradata database.
Temporary File
$PMTempDir\
PowerCenter uses the temporary file name to generate the names for the log file, control file, and the staged output file. Enter a complete path for the file.
Control File Override
Blank
The control file text. Use this attribute to override the control file the Integration Service creates for a session.

0 COMMENTS

We’d like to hear from you!