The only post I saw about this (from January) said I need to implement triggers in my source database. Is that still the case? Or does the free version of data integration have log based change data tracking? If so what type of job component do I use?
With talend open studio, 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 Source DB--> The output will be the changed data.
