Thanks @Louis_Frolio. This is really helpful. I'll implement a downstream transformation to handle the delete records. Appreciate the thorough explanation!