• delete sets that no longer exist - Option to update

    Hello,

    I have a need to update a person record when it no longer exist in the source table.

    HR will at times remove a record from the HR table. The problem is I've already have a person record for it.

    I will need to mark the person record terminated…