Update

Description:

Update is a step in the Output Plugin for Process Studio Workflows. This step is used for updating field in tables.

Configurations:

Field Name	Description
Step Name	Name of the step. This name has to be unique in a single workflow.
Connection	Name of the database connection on which the target table resides.
Target Schema	The name of the Schema for the table to write data to.
Target Table	Name of the target table.
Commit Size	The number of rows after which to commit.
Use batch updates	Select this checkbox to decide if updates are in batch mode.
Skip Lookup	Select this checkbox to skip lookup.
Ignore lookup failure	Select this checkbox to ignore lookup failure.
The keys to lookup the values:
Table field	Field in the table to lookup
Comparator	Select from the list of comparators
Stream field1	Table field is compared with Stream field1 using comparator
Stream field2	Table field is compared with Stream field2 using comparator
Update Fields:
Table field	The field to be updated in the table
Stream field	The field in the stream used to update the table field.
Update	Select Y/N to confirm update