Move Deleted Records into another Table

[RamdasP]

Hi,

Using Qlik Attunity Replicate process is it possible to move records that are deleted from the source into a separate table in the target database or set a flag in the target table to indicate that the record was deleted from the source.

Any suggestions will be highly appreciated.

Kind Regards

Ramdas

[john_wang · Accepted solution]

Hello @RamdasP ,

If you want to keep the 'deleted' rows in the same target table, you may use operation_indicator(value_on_delete, value_on_update, value_on_insert)  function.

If you want to put the 'deleted' rows to a separate target table, then you can use multiple tasks. In one task filter out the 'DELETE' operation rows (keep insert and update rows only, but you may have to use UPSERT mode in this task because of PK violation of insert), in another task (store changes only) stores the 'DELETE' operation rows.

Hope this helps,

John.

[RamdasP]

Thx, John