Can anyone tell me why I am getting blank rows with nothign but the ID from Salesforce during a CDC workflow run? My assumption is that these are rows representing deletes in SFDC. I woudl love to be able to point some documentation that proves this.
This is the case ,when the records has been deleted from salesforce.Let say ,during 1st run ,you have pulled records A and before second run the record A has been deleted from salesforce.
When you pull the records during second run ,then it will bring only the ID for record A and other columns will be NULL.
Using that you can delete the same records in the target table.