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

Advanced Properties

Advanced Properties

The advanced properties allow you to specify data object write operation properties to load data into Teradata tables.
The following table describes the advanced properties that you configure in the data object write operation:
Property
Description
Macro Database
Name of the database that stores the macros Teradata PT API creates when you select the Stream system operator.
The Stream system operator uses macros to modify tables. It creates macros before Teradata PT API begins loading data and removes them from the database after Teradata PT API loads all rows to the target.
If you do not specify a macro database, Teradata PT API stores the macros in the log database.
Truncate Table
Teradata PT API deletes all rows in the Teradata target before it loads data.
This attribute is available for the Stream, Update, and Load system operators.
Default is disabled.
Pause Acquisition
Causes the load operation to pause before writing data to the Teradata PT API target.
Default is disabled.
Query Band Expression
Query band expression to be passed to Teradata PT API.
A query band expression is a set of name-value pairs that identify a query’s originating source. In the expression, each name-value pair is separated by a semicolon and the expression ends with a semicolon. For example, ApplicationName=Informatica;Version=9.5.0;ClientUser=A;.
Mark Duplicate Rows
Specifies how Teradata PT API handles duplicate rows when it tries to insert or upsert rows in the target table.
Select one of the following values:
  • None. If Teradata PT API receives a row marked for insert or upsert that causes a duplicate row in the target table, Teradata PT API does not write the row to the error table and does not mark it as an error row in the workflow log.
  • For Insert. If Teradata PT API receives a row marked for insert that exists in the target table, Teradata PT API writes the row to the error table and marks it as an error row in the workflow log.
  • For Update. If Teradata PT API receives a row marked for update that causes a duplicate row in the target table, Teradata PT API writes the row to the error table and marks it as an error row in the workflow log.
  • Both. If Teradata PT API receives a row marked for insert or upsert that causes a duplicate row in the target table, Teradata PT API writes the row to the error table and marks it as an error row in the workflow log.
Default is For Insert.
The input locale for the value of the Mark Duplicate Rows attribute is in the English language only.
Log Database
Name of the database that stores the log tables.
Log Table Name
Name of the restart log table.
Error Database
Name of the database that stores the error tables.
Error TableName1
Name of the first error table. Use this attribute to override the default error table name.
Error TableName2
Name of the second error table. Use this attribute to override the default error table name.
Drop Log/Error
Drops the existing log and work tables when you run a mapping.
This attribute is available for a Teradata target ODBC connection.
Default is disabled.
Serialize
Uses the Teradata PT API serialize mechanism to reduce locking overhead when you select the Stream system operator.
Default is enabled.
Pack
Number of statements to pack into a request when you select the Stream system operator.
Must be a positive, nonzero integer.
Default is 20. Minimum is 1. Maximum is 600.
Pack Maximum
Causes Teradata PT API to determine the maximum number of statements to pack into a request when you select the Stream system operator.
Default is disabled.
Buffers
Determines the maximum number of request buffers that may be allocated for the Teradata PT API job when you select the Stream system operator.
Must be a positive, nonzero integer.
Default is 3. Minimum is 2.
Error Limit
Maximum number of records that can be stored in the error table before Teradata PT API terminates the Stream system operator job.
Must be -1 or a positive, nonzero integer.
Default is -1, which specifies an unlimited number of records.
Replication Override
Specifies how Teradata PT API overrides the normal replication services controls for an active Teradata PT API mapping.
Select one of the following values:
  • On. Teradata PT API overrides normal replication services controls for the active mapping.
  • Off. Teradata PT API disables override of normal replication services for the active mapping when change data capture is active.
  • None. Teradata PT API does not send an override request to the Teradata Database.
Default is None.
The input locale for the value of the Replication Override attribute is in the English language only.
Driver Tracing Level
Determines Teradata PT API tracing at the driver level.
Select one of the following values:
  • TD_OFF. Teradata PT API disables tracing.
  • TD_OPER. Teradata PT API enables tracing for driver-specific activities for Teradata.
  • TD_OPER_ALL. Teradata PT API enables all driver-level tracing.
  • TD_OPER_CLI. Teradata PT API enables tracing for activities involving CLIv2.
  • TD_OPER_NOTIFY. Teradata PT API enables tracing for activities involving the Notify feature.
  • TD_OPER_OPCOMMON. Teradata PT API enables tracing for activities involving the operator common library.
Default is TD_OFF.
The input locale for the value of the Driver Tracing Level attribute is in the English language only.
Infrastructure Tracing Level
Determines Teradata PT API tracing at the infrastructure level.
Select one of the following values:
  • TD_OFF. Teradata PT API disables tracing.
  • TD_OPER. Teradata PT API enables tracing for driver-specific activities for Teradata.
  • TD_OPER_ALL. Teradata PT API enables all driver-level tracing.
  • TD_OPER_CLI. Teradata PT API enables tracing for activities involving CLIv2.
  • TD_OPER_NOTIFY. Teradata PT API enables tracing for activities involving the Notify feature.
  • TD_OPER_OPCOMMON. Teradata PT API enables tracing for activities involving the operator common library.
Default is TD_OFF.
You must enable the driver tracing level before you can enable the infrastructure tracing level.
The input locale for the value of the Infrastructure Tracing Level attribute is in the English language only.
Trace File Name
File name and path of the Teradata PT API trace file.
Default path is
$<Informatica installation directory>\tomcat\bin
.
Default file name is
<Name of the TPT Operator>_timestamp
. For example,
LOAD_20091221
.
System Operator
Specifies the Teradata PT API operator type.
Select one of the following values:
  • Load. Performs bulk loading into an empty Teradata database table. You can use the Load system operator in native and Hadoop environments.
  • Stream. Performs insert, update, upsert, and delete operations against Teradata database tables in near real-time mode. You can use the Stream system operator in native and Hadoop environments.
  • Update. Performs insert, update, upsert, and delete operations against Teradata database tables. You can use the Update system operator in native and Hadoop environments.
Default is Stream.
The input locale for the value of the System Operator attribute is in the English language only.
Mark Missing Rows
Specifies how Teradata PT API handles rows that do not exist in the target table when it tries to update or delete rows.
Select one of the following values:
  • None. If Teradata PT API receives a row marked for update or delete but it is missing in the target table, Teradata PT API does not write the row to the error table and does not mark it as an error row in the workflow log.
  • For Update. If Teradata PT API receives a row marked for update but it is missing in the target table, Teradata PT API writes the row to the error table and marks it as an error row in the workflow log.
  • For Delete. If Teradata PT API receives a row marked for delete but it is missing in the target table, Teradata PT API writes the row to the error table and marks it as an error row in the workflow log.
  • Both. If Teradata PT API receives a row marked for update or delete but it is missing in the target table, Teradata PT API writes the row to the error table and marks it as an error row in the workflow log.
Default is None.
The input locale for the value of the Mark Missing Rows attribute is in the English language only.
Mark Extra Rows
Specifies how Teradata PT API marks error rows when it tries to update or delete multiple target table rows.
Select one of the following values:
  • None. If Teradata PT API receives a row marked for update or delete that affects multiple rows in the target table, Teradata PT API does not write the row to the error table and does not mark it as an error row in the workflow log.
  • For Update. If Teradata PT API receives a row marked for update that affects multiple rows in the target table, Teradata PT API writes the row to the error table and marks it as an error row in the workflow log.
  • For Delete. If Teradata PT API receives a row marked for delete that affects multiple rows in the target table, Teradata PT API writes the row to the error table and marks it as an error row in the workflow log.
  • Both. If Teradata PT API receives a row marked for update or delete that affects multiple rows in the target table, Teradata PT API writes the row to the error table and marks it as an error row in the workflow log.
Default is Both.
This attribute is available only for the Stream system operator.
The input locale for the value of the Mark Extra Rows attribute is in the English language only.
Insert
Teradata PT API creates a DML group to insert rows.
If you do not want to insert rows, clear this option to increase session performance.
Default is selected.
Update
Teradata PT API creates a DML group to update rows.
Default is not selected.
Upsert
Teradata PT API creates a DML group to update or insert rows.
Default is not selected.
Delete
Teradata PT API creates a DML group to delete rows.
Default is not selected.
WorkTable Database Name
Name of the database that stores the work tables.
Use this attribute to override the default work table database name. If you do not specify a database name, the Data Integration Service uses the target table database.
WorkTable Name
Name of the work tables when you select the Update system operator.
The Teradata database creates one work table for each target table. If you do not specify a work table name, the Data Integration Service uses the name <work_table_database>.INFA<number>_WT. The exact table name appears in the session log.
Pre SQL
Pre-session SQL commands to run against the source database before the Data Integration Service reads the source.
Post SQL
Post-session SQL commands to run against the source database after the Data Integration Service writes to the target.
If you set the custom property EnableTdch to true, the advanced properties in the data object write operation are not applicable.
If you run the mapping on a Hortonworks or Cloudera cluster and on the Blaze engine, only the
Truncate Table
property is supported.


Updated October 05, 2018