Refresh Data (Processing Option)

During processing of a transfer request the SLIK server  attempts to fetch and insert each row into the destination table .  If the insert fails the default policy (processing option) is to terminate further processing.  However, if the processing option has been set to “Refresh Data” and the reason the insert failed was due to there already being existing data with the same key value then the SLIK server will construct an SQL “UPDATE TABLE” statement.  This is achieved by attempting to determine the “Primary Key” for the WHERE  clause and then performing “SET column = value” on all other columns.