Hi Talend Folks,
I want to know how to use CDC concept step by step in talend enterprise version.
I am using sources database is db2 and destination database is postgres.
I am beginner for talend. so please share information to me.
i have tried this link https://help.talend.com/reader/_Qg2guINsDl6hsiB7uKWzQ/XjnjnnjKf5G8OuLt9h8xZw
but its not working.
when i create CDC connection it will not show other database connection.
What's the error you are getting when setting up your CDC environment? Are you using talend subscription solution 6.1?
You can match the tables and compare all records to conclude the needed inserted records, updated records, and deleted records.
If you want to capture the changed data and only load these changed data into target table to achieve table sync, you can compare tables by using tMap.
The work flow should be: Target DB-->tMap(make inner join on your input and set the "Catch lookup inner join reject" as true)-->output
The output will be the changed data.
Let us know if it is OK with you.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables