Table of Contents

Search

  1. Preface
  2. Workflow Manager
  3. Workflows and Worklets
  4. Sessions
  5. Session Configuration Object
  6. Tasks
  7. Sources
  8. Targets
  9. Connection Objects
  10. Validation
  11. Scheduling and Running Workflows
  12. Sending Email
  13. Workflow Monitor
  14. Workflow Monitor Details
  15. Session and Workflow Logs
  16. Session Properties Reference
  17. Workflow Properties Reference

Target Properties

Target Properties

You can configure session properties for relational targets in the Transformations view on the Mapping tab, and in the General Options settings on the Properties tab. Define the properties for each target instance in the session. When you click the Transformations view on the Mapping tab, you can view and configure the settings of a specific target. Select the target under the Targets node.
The following table describes the properties available in the Properties settings on the Mapping tab of the session properties:
Target Property
Description
Target Load Type
You can choose Normal or Bulk.
If you select Normal, the Integration Service loads targets normally.
You can choose Bulk when you load to DB2, Sybase, Oracle, or Microsoft SQL Server. If you specify Bulk for other database types, the Integration Service reverts to a normal load. Loading in bulk mode can improve session performance, but limits the ability to recover because no database logging occurs.
Choose Normal mode if the mapping contains an Update Strategy transformation.
If you choose Normal and the Microsoft SQL Server target name includes spaces, configure the following connection environment SQL in the connection object:
SET QUOTED_IDENTIFIER ON
Insert
Integration Service inserts all rows flagged for insert.
Default is enabled.
Update (as Update)
Integration Service updates all rows flagged for update.
Default is enabled.
Update (as Insert)
Integration Service inserts all rows flagged for update.
Default is disabled.
Update (else Insert)
Integration Service updates rows flagged for update if they exist in the target, then inserts any remaining rows marked for insert.
Default is disabled.
Delete
Integration Service deletes all rows flagged for delete.
Default is disabled.
Truncate Table
Integration Service truncates the target before loading.
Default is disabled.
Reject File Directory
Reject-file directory name. By default, the Integration Service writes all reject files to the service process variable directory, $PMBadFileDir.
If you specify both the directory and file name in the Reject Filename field, clear this field. The Integration Service concatenates this field with the Reject Filename field when it runs the session.
You can also use the $BadFile
Name
session parameter to specify the file directory.
Reject Filename
File name or file name and path for the reject file. By default, the Integration Service names the reject file after the target instance name:
target_name
.bad. Optionally, use the $BadFile
Name
session parameter for the file name.
The Integration Service concatenates this field with the Reject File Directory field when it runs the session. For example, if you have “C:\reject_file\” in the Reject File Directory field, and enter “filename.bad” in the Reject Filename field, the Integration Service writes rejected rows to C:\reject_file\filename.bad.