Azure Data Factory- Updating or Inserting Values from and to the same source and target table

Question

I have a job in Azure Data Factory, which takes date value from source table (which is also target table), applies expression with 'DerivedColumn' component on date value and fills the target table column(last_7_days) with the output which is boolean after application of expression. My table is large so truncate table isn't an option since I will be truncating same source. I basically want to either insert or update values to last_7_days column. The other data in the table will remain static and won't change. Since I am new to ADF, any help will be appreciated.

Preview of data is also giving me correct value after expression implementation :

My main aim is to fill up target table with this value after implementation of expression. My sink looks like this:

I will appreciate any Tips or Suggestion. Thank you so much for helping.

Answer 1

I have implemented in following way and it is working fine. Attaching the JSON as well..