If the data is deleted in Salesforce after replication (Source to DB), when the replication (Source to DB) is run for the next time, do_sync_flag value changes to ‘D’. Example: Account ‘Pyramid Construction Inc.’ is deleted in Salesforce which is already replicated in database. Account Pyramid Construction Inc. data is already available in database with do_sync_flag value ‘Y’. When the Source to DB replication is done for the next time, do_sync_flag value changes to ‘D’ by itself. This signifies that Account ‘Pyramid Construction Inc.’ does not exist in Salesforce.
After Replication (Source to DB), do_sync_flag value is ‘Y’ for the account ‘Pyramid Construction Inc.’
Account ‘Pyramid Construction Inc.’ is deleted in Salesforce.
After Replication (Source to DB), do_sync_flag value changes to ‘D’.