Four Stars

oracle

Hi,

I having a job like this

 

Oralceinput--->oracleoutput.

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.

1 REPLY
Moderator

Re: oracle

Hello,

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

Sabrina

 

 

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