Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange for Teradata Parallel Transporter API
  3. PowerExchange for Teradata Parallel Transporter API Configuration
  4. PowerExchange for Teradata Parallel Transporter Connections
  5. PowerExchange for Teradata Parallel Transporter API Data Objects
  6. PowerExchange for Teradata Parallel Transporter API Mappings
  7. Teradata Parallel Transporter API Run-time Processing
  8. Data Type Reference

PowerExchange for Teradata Parallel Transporter API User Guide

PowerExchange for Teradata Parallel Transporter API User Guide

Parameterization

Parameterization

You can parameterize Teradata data object operation properties to override the read and write data object operation properties during run time.
In bulk mode, you can parameterize the following data object read operation properties for Teradata sources:
  • Pre SQL
  • Post SQL
  • Select Distinct
  • Select SQL Statement
  • Query Band Expression
  • Source Table Name
  • Source Table Schema
  • Driver Tracing Level
  • Infrastructure Tracing Level
  • Trace File Name
  • Spool Mode
In bulk mode, you can parameterize the following data object write operation properties for Teradata targets:
  • Macro Database
  • Truncate Table
  • Pause Acquisition
  • Query Band Expression
  • Mark Duplicate Rows
  • Log Database
  • Log Table Name
  • Error Database
  • Error Table Name1
  • Error Table Name2
  • Drop Log/Error
  • Serialize
  • Pack
  • Pack Minumum
  • Buffers
  • Error Limit
  • Replication Override
  • Driver Tracing Level
  • Infrastructure Tracing Level
  • Trace File Name
  • System Operator
  • Mark MISSING Rows
  • Mark EXTRA Rows
  • Insert
  • Update
  • Upsert
  • Delete
  • WorkTable Database Name
  • WorkTable Name
  • Pre SQL
  • Post SQL
The following attributes support partial parameterization:
  • Query Band Expression
  • Trace File Name


Updated October 05, 2018