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.
Watch the recorded webinar!
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.