Table of Contents

Search

  1. Preface
  2. Workflows
  3. Workflow Variables
  4. Workflow Parameters
  5. Cluster Tasks
  6. Command Task
  7. Human Task
  8. Mapping Task
  9. Notification Task
  10. Gateways
  11. Workflow Recovery
  12. Workflow Administration

Developer Workflow Guide

Developer Workflow Guide

Configuring a Mapping to Run an SQL Command

Configuring a Mapping to Run an SQL Command

To support a complete restart of a mapping that writes to a relational target, write an SQL command that the Data Integration Service runs to delete target rows before it reads the source.
  1. Select the Mapping task in the editor.
  2. In the
    Properties
    view, click the
    General
    tab.
  3. Click the name of the mapping that the task runs.
    The mapping opens.
  4. Select the relational data object in the editor.
  5. In the
    Properties
    view, click the
    Advanced
    tab.
  6. In the
    Value
    column for the
    PreSQL
    property, click the
    Open
    button.
    The
    SQL Query
    editor appears.
  7. Enter an SQL command and then click
    OK
    .
    The Developer tool does not validate the SQL.
    The following figure shows an SQL command that deletes all rows written today from the table named DEPT:
  8. Click
    File
    Save
    to save the mapping.

0 COMMENTS

We’d like to hear from you!