Property | Description |
|---|---|
Write Strategy | The write strategy for the operation. You can select Insert, Upsert, Update, and Delete. |
Data Serialization Format | Overrides the format specified in the OData V2 Protocol Writer connection in which the data is transferred over the network. You can select from one of the following formats:
Default is JSON. |
Cache Size for Web Service Request (KB) | Memory available for the web service request. If the web service request contains many rows or columns, you might want to increase the cache size. Default is 100 KB. |
Cache Size for Web Service Response (KB) | Memory available for the web service response. If the web service response contains many rows or columns, you might want to increase the cache size. Default is 100 KB. |
Allow Input Flush | The mapping task creates XML when it has all of the data for a group. When enabled, the mapping task flushes the XML after it receives all of the data for the root value. When not enabled, the mapping task stores the XML in memory and creates the XML after it receives data for all the groups. You cannot select the option to allow input flush if you are connecting to multiple source objects. |
Transaction Commit Control | Control to commit or roll back transactions based on the set of rows that pass through the transformation. Use the transaction commit control if you have a large amount of data and you want to control how it is processed. |
Transformation Scope | The method in which the Secure Agent applies the transformation logic to incoming data. Default is All Input. |