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

Teradata Array Insert

Teradata Array Insert

When you use ODBC to write data to a Teradata target, you can insert arrays of data into the target instead of inserting data row by row. Inserting arrays of data results in better session performance.
To insert arrays of data into a Teradata target by using ODBC, configure the OptimizeTeradataWrite custom property at the session level or at the PowerCenter Integration Service level. Set the value of the OptimizeTeradataWrite custom property to 1 to insert arrays of data into the target.
Note that the OptimizeTeradataWrite custom property is applicable only for inserting data into the target, and not for updating data in the target, deleting data from the target, or reading data from the source.