I'm trying to use "ALL ROWS" keyword in the Sql code, but it gives me the following error "ALL ROWS not allowed in this context", while using the Salesforce connector.
you should use Select_ALL and IsDeleted=True as a condition.
View solution in original post
What about deletes in incremental loads? This solution of IsDeleted = true holds good for full load.
Hi is it possible that you be more specific about how to use Select_ALL? Thank you so much for your help!