how to delete rows that where not found before updating current ones?

[ogonzalesdiaz]

Hi, currently my Update activity matches existing rows with rows comming from an external file, on @codtarjeta field. 

However, this will only update the rows where a match is found, leaving old rows unmodified and still in DB. 

Is there a setting I can use in the update activity, to tell it to: "delete rows in data base that are not comming any more from the external file"? 

[ParthaSarathy · Accepted solution]

Hi @ogonzalesdiaz ,

You can modify your workflow as below,

After data loading, using enrichment reconcile the temp data with targeting schema using reconciliation key.

In Change dimension, select your targeting dimension, And next insert or Update the records.

Parallelly, Query all the records from your schema, and exclude the records which is present in the file using exclusion activity and delete the records using Update data activity.