Data Engineering Integration All Products
SQL command that the Data Integration Service runs against the source database before it reads from the source.
SQL command that the Data Integration Service runs against the source database before it writes to the target.
Specifies if you want to select only unique rows. The Data Integration Service includes a SELECT DISTINCT statement if you choose this option.
Select SQL Statement
This property is applicable in the following scenarios:
Enter an SQL statement to override the default query. You can specify the columns that you want to use from the source database.
You can also parameterize the SQL statement.
Query Band Expression
The query band expression to be passed to the 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;.
Source Table Name
Table name from which you want to extract rows.
Source Table Schema
Schema name from which you want to extract rows.
Driver Tracing Level
Determines Teradata PT API tracing at the driver level:
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:
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,
You can choose one of the following spool modes:
Determines the spool mode Teradata PT API uses to extract data from Teradata.
Default is Spool.
The input locale for the value of the Spool Mode attribute is in the English language only.