Teradata Connector > Mappings and Mapping Tasks with Teradata > Teradata Objects in Mappings
  

Teradata Objects in Mappings

When you create a mapping, you can configure a Source transformation to represent a Teradata object. After you configure a mapping, deploy the mapping in a mapping task.

Teradata Sources in Mappings

In a mapping, you can configure a Source transformation to represent a single Teradata source or multiple Teradata sources.
The following table describes the Teradata source properties that you can configure in a Source transformation:
Property
Description
Connection
Select the source connection, or click New Connection to create one. Alternatively, you can define a connection parameter in the mapping and enter a specific connection in each mapping task that is associated with the mapping.
Source type
Type of the source object. Select one of the following types:
  • - Single Object. Select to specify a single Teradata object.
  • - Multiple Objects. Select to specify multiple Teradata objects.
  • - Parameter. Select to specify a parameter name. You can configure the source object in a mapping task associated with a mapping that uses this source transformation.
Object
Name of the source object. Select the source object for a single source.
When you select the multiple source objects option, you can add multiple related source objects and configure relationships between them. You can use existing relationships or custom relationships to join multiple source objects. When you create a custom relationship for Teradata objects, you can select the type of join and the source fields to use.
If you select Parameter, create or select the parameter for the source object.
The following table describes the Teradata source advanced properties that you can configure in a Source transformation:
Advanced Property
Description
Driver Tracing Level
Determines Teradata PT API tracing at the driver level:
  • - TD_OFF. Teradata PT API disables tracing.
  • - TD_OPER. Teradata PT API enables tracing for driver-specific activities for Teradata.
  • - TD_OPER_CLI. Teradata PT API enables tracing for activites 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.
  • - TD_OPER_ALL. Teradata PT API enables all driver-level tracing.
Default is TD_OFF.
Infrastructure Tracing Level
Determines Teradata PT API tracing at the infrastructure level:
  • - TD_OFF. Teradata PT API disables tracing.
  • - TD_OPER. Teradata PT API enables tracing for driver-specific activities for Teradata.
  • - TD_OPER_CLI. Teradata PT API enables tracing for activites 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.
  • - TD_OPER_ALL. Teradata PT API enables all driver-level tracing.
Default is TD_OFF.
You must enable the driver tracing level before you can enable the infrastructure tracing level.
Trace File Name
File name and path of the Teradata PT API trace file.
Default path is $PM_HOME. Default file name is <Name of the TPT Operator>_timestamp. For example, EXPORTER_20091221.
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.0.1;ClientUser=A;.
Spool Mode
Determines the spool mode Teradata PT API uses to extract data from Teradata.
You can select one of the following spool modes:
  • - Spool. Teradata PT API spools data while extracting data from Teradata.
  • - NoSpool. Teradata PT API does not spool data while extracting data from Teradata. If the database does not support the NoSpool option, Teradata PT API uses the Spool option.
  • - NoSpoolOnly. Teradata PT API does not spool while extracting data from Teradata.
Default is Spool.
SQL Override Query
The SQL statement to override the default query used to read data from the Teradata source. The data type, number, and order of columns in the select clause must match with the Teradata source object.
Select Distinct
Selects distinct rows and eliminates duplicate rows.
Tracing Level
Determines the amount of detail that appears in the log for the source. you can choose Terse, Normal, Verbose Initialization, or Verbose Data tracing level.
Default is Normal.