I have developed a simple job which loads the data from Oracle to Amazon redshift data base table. I have implemented to Insert and Update on the target table using two flows in the job.please see below
I put a condition in the tmap to route the inner join matches records to update flow and join rejected records to Insert flow.
Above flow is working for oracle without any issues but not for Redshift.
below is the screenshot when job used target tables as Redshift tables
@aannamaneni , as part of testing if you keep one redshift table ,is that job working perfectly?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables