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

JDBC Targets in Mappings

When you configure a mapping to use a JDBC target, you can configure target properties.
Specify the name and description of the JDBC target. Configure the target and advanced target properties for the JDBC object.
The following table describes the target properties that you can configure in a Target transformation:
Property
Description
Connection
Name of the target connection.
Target Type
Target type. Select one of the following target types:
  • - Single. Select to specify a single JDBC object.
  • - Multiple. Select to specify multiple JDBC objects. You must specify the source object, related source object, and configure the relationship between the source objects. Related objects appear based on simple primary key or composite keys object relationship.
  • - Parameter. Select to specify a parameter name. You can configure the source object in a Mapping Configuration task associated with a mapping that uses this source transformation.
Object
Name of the target object. You can select an existing object or create an object at runtime.
Operation
Target operation. Select one of the following operations:
  • - Insert.
  • - Update.
  • - Upsert.
  • - Delete.
  • - Data Driven. Configure an expression to specify an update strategy based on the data. You can use one of the following constants in an expression:
    • - DD_INSERT
    • - DD_UPDATE
    • - DD_REJECT
    • - DD_DELETE
Note: If you use the Data Driven operation, you cannot upsert.
The following table describes the JDBC advanced target properties:
Advanced Target Property
Description
Commit Interval
Interval in rows between commits. Default is 100.
Number of Retries
An integer value. Number of times to retry if the query execution fails due to a closed connection. Default is 5.
Retry Wait Period
Interval in seconds between two retry attempts. Default is 3 seconds.
Success File Directory
Directory for the success file. Specify a directory path that is available on each Secure Agent machine in the runtime environment. By default, Informatica Cloud writes the success file to the following directory: <Secure Agent installation directory>/main/rdtmDir/success
Enter a directory local to the Secure Agent. Ensure that your administrator has granted you access to this directory.
Error File Directory
Directory for the error rows file. Specify a directory path that is available on each Secure Agent machine in the runtime environment. By default, Informatica Cloud writes the error rows file to the following directory: <Secure Agent installation directory>/main/rdtmDir/error
Enter a directory local to the Secure Agent. Ensure that your administrator has granted you access to this directory.
Forward Reject Rows
Determines whether the transformation passes rejected rows to the next transformation or drops rejected rows. By default, the Mapping Configuration application forwards rejected rows to the next transformation.