I'm using Talend Open Studio for Data Integration (6.4.0).
Moving data from Oracle to PostgreSQL; only want to update the PostgreSQL tables with new records from Oracle.
Previous successful run, I store the 'Last_Update_Date' in a separate table in PostgreSQL.
The Oracle input tables have a 'Create_Date' field, which I can compare to the PostgreSQL 'Last_Update_Date', and only keep the Oracle records which have date greater than 'Last_Update_Date'.
In summary, I want to:
Read Oracle tables, compare 'Create_Date' to the 'Last_Update_Date' I previously stored in a PostgreSQL table, insert only new records into the PostgreSQL tables.
Thanks for the help!
Solved! Go to Solution.