Table of Contents

Search

  1. Preface
  2. Data integration tasks
  3. Mapping tasks
  4. Dynamic mapping tasks
  5. Synchronization tasks
  6. Data transfer tasks
  7. Replication tasks
  8. Masking tasks
  9. Masking rules
  10. PowerCenter tasks

Tasks

Tasks

Configuring the target

Configuring the target

You can write data to a single target. You can select an existing target object or create a new object at run time. If you create a target at run time, the task operation is Insert.
  1. On the
    Target
    page, configure the following properties as required:
    Property
    Description
    Connection
    Select a connection.
    To create a connection, click
    New
    . To edit a connection, click
    View
    , and the in
    View Connection
    dialog box, click
    Edit
    .
    To configure advanced properties for the connection, click
    Advanced Options
    . Not available for all connections types.
    For information about a particular connector's properties, see the help for the appropriate connector.
    Object
    Select a target object.
    Click
    Select
    . The
    Select Target Object
    dialog box displays up to 200 objects. If the object you want to use does not display, enter a search string to reduce the number of objects that display.
    Target operation
    Select one of the following task operations:
    • Insert
    • Update
    • Upsert
    • Delete
    • Data Driven
    The operations available depend on the target connection.
    Formatting Options
    For flat file
    and FTP/SFTP
    connections only. Select a delimiter and text qualifier. Optionally, select an escape character.
    If you choose Other for the delimiter, the delimiter cannot be an alphanumeric character or a double quotation mark.
    If you choose a delimiter for an FTP/SFTP flat file,
    Data Integration
    applies the delimiter to the local file, not the remote file, when previewing and reading data. If the remote and local files are not synchronized, you might see unexpected results.
    Truncate Target
    Database targets with the Insert task operation only. Truncates a database target table before inserting new rows.
    • True. Truncates the target table before inserting all rows.
    • False. Inserts new rows without truncating the target table.
    Default is False.
    Enable Target Bulk Load
    Select this option to write data in bulk mode. The default value is false.
  2. For database targets, configure update columns if necessary.
  3. If preview data does not appear automatically, expand the Data Preview area to preview the target data.
  4. Click
    Next
    .

0 COMMENTS

We’d like to hear from you!