You need to configure table in LTRS and define for the table "Refresh behavior" as "nothing". In such case the target table will not be recreated or truncated and the new data will be simply added to existing table.
But you have risk to get an double key error if newly inserted data will have same key. If it's ok for you and you would like to overwrite existing data, then you can define "writing behavior" for the table as "Array Modify" under Performance Option parameters. Or define an own rule that somehow change the incoming records in way that they will not conflict with existing data.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.