Four Stars



I having a job like this



In my source oralce table 100 records are there and i loaded 100 records for first run and than 10 new records are added to the source.Now i run the job it only read the latest 10 records not all 100+10 records.How we can achieve this in talend.


Re: oracle


There are several ways to have an incremental load.
If there is not too much data, you might consider using a tMap which inner joins existing data with all data and then have an output which catches the reject of inner join.

Please refer to talend CDC feature TalendHelpCenter:Change Data Capture (CDC): publish/subscribe which can capture only the changed source data and to move it from a source to a target system(s) in real time.

Best regards




Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.