English
  • PowerCenter 10.2 HotFix 2
  • All Products

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

Workflow Basics Guide

Workflow Basics Guide

Back Next

Truncating a Target Table

Truncating a Target Table

When you truncate target tables, you can choose to truncate tables on a target-by-target basis
  1. In the Workflow Manager, open the session properties.
  2. Click the Mapping tab, and then click the Transformations view.
  3. Click the Targets node.
  4. In the Properties settings, select Truncate Target Table Option for each target table you want the Integration Service to truncate before it runs the session.
  5. Click OK.