Hi , i am using tap-mysql and taget-redshift to load table from a mysql table to redshift . I am using "LOG_BASED" replication-method . The issue is using this method the updated records are getting reflected in final table but deleted records still exists in final table. Am i missing something ?

select:
- db_test-bpp_jobs_meltano.*
metadata:
  db_test-bpp_jobs_meltano:
    replication-method: LOG_BASED

Second this is i want a prefix in table name when ingesting from source to target-redshift , but again it is not working as expected.

table_prefix: CDC_

Can anyone tell me where am i going wrong ?