Update

Description:

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

Configurations:

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