Insert Truncate Existing Option

create an attribute with with your requirement like "updating / adding/ removing " before the writer and pass this in the parameter and should be given in FEATURE OPERATION in the palette you were showing.

The Feature Operation parameter will have an option for fme_db_operation. This means it will be look for an attribute on incoming features named fme_db_operation. Within your workspace create this attribute with values of either INSERT, UPDATE, or DELETE, which will be honored by the writer.

Thanks both @srinivasgg​  and @dustin​ for the response.

Would I be able to create the new attributes all in one transformer such as the below (each named fme_db_operation with a different attribute value of INSERT, UPDATE, DELETE or would that be separate transformers for each , named something else?)

Also with my writer, if I select the fme_db_operation option, would I then still be choosing truncate existing in the table handling, saying yes to spatial handling and then matchign the columns to the same fme_db_operation attribute?

I'd just want to ensure that all 3 (any updates/inserts/deletions) from the source are written or updating the feature class in the file geodatabase in the writer.

Thanks so much

Have a look at the ChangeDetector transformer. This will automaticall categorise features as deleted/inserted/updated/unchanged and set the fme_db_operation attribute to the correct value.

In your most recent reply, you'd have table handling as use existing, update spatial as yes and the match column as the object id