Preface
Workflow Manager
Workflows and Worklets
Sessions
Session Configuration Object
Tasks
Sources
Targets
Connection Objects
Validation
Scheduling and Running Workflows
Sending Email
Workflow Monitor
Workflow Monitor Details
Session and Workflow Logs
Appendix A: Session Properties Reference
Appendix B: Workflow Properties Reference

Workflow Basics Guide

10.4.0
- 10.5

Back Next

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.

Rename Saved Search

Table of Contents

Workflow Basics Guide

Workflow Basics Guide

Teradata Array Insert

Teradata Array Insert