Hi, And welcome to Talend. There are several ways to have an incremntal 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 rejest of inner join. Talend also has some nice components on CDC for example tOracleCDC for changed data capturing. Please read the component guide on details of these components.
Hi, Please suggest the best way to do incremental load into hive tables based on date column. final data must be synchronized with source relational Database like all changes in source DB must be reflect in Hive tables (i.e update/delete records). Thanks, Sachin Sharma