Transformations > Target transformation > Configuring a Target transformation
  

Configuring a Target transformation

You can use an existing target or create a target to hold the results of a mapping. If you choose to create the target, the Secure Agent creates the target when you run the task.
    1. Select the Target transformation in the mapping.
    2. On the General tab, enter a target name and optional description
    3. On the Incoming Fields tab, configure field rules that specify the fields to include in the target
    For more information about field rules, see Field rules.
    4. On the Target tab, select the target connection and specify the target type, for example, Single Object or Parameter.
    The option to select multiple objects is available for NetSuite connections only.
    5. To use an input parameter for the target object, select an existing parameter, or click New Parameter and create a new parameter for the target object.
    6. To use an existing target object, either enter the object name or click Select and select the target object.
    7. To create a new target object, perform the following steps:
    1. a. Click Select.
    2. b. In the Target Object dialog box, select Create New at Runtime:
    3. The image shows the Target Object dialog box for a flat file target. The "Create New at Runtime" option is selected and the "Use a Dynamic File Name" check box is not checked. Because a dynamic file name is not selected, the Static File Name field appears at the bottom of the dialog box. The name "MyTarget.csv" is entered in the Static File Name field.
    4. c. For flat file targets, enter the name of the target file including the extension, for example, Accounts. csv.
    5. If you want the file name to include a time stamp, select Handle Special Characters and add special characters to the file name, for example, Accounts_%d%m%y%T.csv.
      If you want to use a dynamic file name, select Use a Dynamic File Name and configure the file name expression.
    6. d. For relational targets, enter the table name.
    7. e. Click OK.
    8. To configure formatting options for flat file targets, click Formatting Options, and configure the formatting options such as the delimiter character and text qualifier.
    9. For relational targets, select the target operation and related properties such as whether to truncate the table for Insert operations.
    If you create a relational target at run time, the target operation is always Insert.
    10. Specify advanced properties for the target, if required.
    Advanced properties vary based on the connection type. For information about connector properties, see the help for the appropriate connector.
    11. Configure the target fields on the Target Fields tab.
    You can edit field names and metadata, add fields, and delete unnecessary fields.
    If you create the target at run time, you cannot configure target fields.
    12. Map incoming fields to target fields on the Field Mapping tab.
    If you create the target at run time, fields are mapped automatically.
    For more information about field mapping, see Target transformation field mappings.