Hi, I tried to sync the table with Incremental | D...
# advice-data-ingestion
p
Hi, I tried to sync the table with Incremental | Deduped + history mode in Airbyte and the issue is when I deleted some records in the source(MSSQL Server), the table in the destination(Big Query) doesn't seem to remove those records, I already enable CDC btw. issue only occur in deduped table, not in history table which has "_scd" in suffix. It works fine with update transaction.
How can I get only active row in the destination table.