Hi Experts...i am planning to use Airbyte to repli...
# ask-community-for-troubleshooting
s
Hi Experts...i am planning to use Airbyte to replicate (postgres to postgres) our ERP Database (150 GB), but selective tables only. Is Airbyte the right choice ? Also, I have installed Airbyte and did some extraction and having configured CDC and Full refresh Overwrite, basic normalization, etc. But, what I see is that any updated row at source is duplicated at the destination. Help me to understand what I misconfigured. Thank you.
d
We typically recommend using dedup + history with CDC since CDC logs all changes to a row so the same primary key can appear multiple times.
s
Thank you @Davin Chia (Airbyte) let me try that way and revert back here if stuck at something...
👍 1