ODBC Connector Guide > Mappings and Mapping Configuration Tasks with ODBC Connector > ODBC Targets in Mappings
  

ODBC Targets in Mappings

In a mapping, you can configure a Target transformation to represent a single ODBC target.
The following table describes the ODBC target properties that you can configure in a Target transformation:
Property
Description
Connection
Name of the target connection.
Target Type
Type of target object. Select Single Object or Parameter.
Object
The target object for the task. Select the target object.
Parameter
The parameter for the target object. Create or select the parameter for the target object.
Note: The parameter field appears only if you select parameter as the target type.
Operation
The target operation. Select the target operation. Select Insert, Update, Upsert, Delete or Data Driven.
Truncate Target
Truncates the database target table before inserting new rows. Select one of the following options:
  • - True. Truncates the target table before inserting all rows.
  • - False. Inserts new rows without truncating the target table
Default is False.
Note: The truncate target property is not applicable for virtual tables.
Forward Rejected Rows
Determines whether the transformation passes rejected rows to the next transformation or drops rejected rows. By default, the Mapping Configuration task forwards rejected rows to the next transformation.