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.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.