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 Truncate a Relational Target

Configuring a Mapping to Truncate a Relational Target

To support a complete restart of a mapping that writes to a relational target, configure the mapping to truncate the target before it loads data.
  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. Select
    Truncate Target Table
    .
    The following figure shows a mapping that is configured to truncate a relational target:
  7. Click
    File
    Save
    to save the mapping.

0 COMMENTS

We’d like to hear from you!