Select key columns (optional)
This option is available only if you selected Write continuous changes directly (MERGE mode) in the source properties. With the default setting Write continuous changes as audit records (APPEND ONLY mode), key columns are not required or used.
By default, when a source table does not have a primary key, Striim will concatenate the values of all columns to create a unique identifier key for each row to identify it for UPDATE and DELETE operations. Alternatively, you may manually specify one or more columns to be used to create this key. Be sure that the selected column(s) will serve as a unique identifier; if two rows have the same key that may produce invalid results or errors.