Insert / Update

Description:

Insert / Update writes rows to a database table by first looking up each row using specified key fields. If a matching record exists, it updates the row; if no match is found, it inserts a new row. Use this step when your workflow needs to maintain a target table that stays current with incoming data — for example, keeping a customer master table in sync with daily feed files or maintaining a product catalog from periodic imports.

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.
Don’t perform any updates	Select this checkbox to perform only insert.
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