I am looking for good practices on propagading the DELETE operations over the Meltano ELT. As one of the things mentioned in the article below, it seems to me that propagation of DELETEs are not supported in target-oracle so I'd have to implement it myself. How? My guess is that I should be looking at

_sdc_deleted_at

timestamps (if produced by tap-oracle) and use DBT transformations to handle these. Would this be the recommended way? Does anyone know whether tap-oracle correctly produces these timestamps? More generally, I am of an impressions that deletes are rarely implemented by the targets. Am I correct and if so, why is it so? I understand they are somewhat more tricky to implement than barebones inserts, however they seem to me quite an important and probably quite frequent requirement for proper ETL. How are people in general dealing with this problem? https://medium.com/@pp_85623/meltano-in-action-hands-on-evaluation-of-an-open-source-elt-framework-5a1d5b93b483