Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can we achieve Change Data Capture in Talend without using tpostgrecdc component ? If yes please let me know how to do it
Hello,
With talend open solution, it is possible 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 workflow should be:
Target DB-->tMap(make inner join on your input and set the "Catch lookup inner join reject" as true)-->output
Source DB-->
The output will be the changed data.
Best regards
Sabrina
Hello,
With talend open solution, it is possible 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 workflow should be:
Target DB-->tMap(make inner join on your input and set the "Catch lookup inner join reject" as true)-->output
Source DB-->
The output will be the changed data.
Best regards
Sabrina