Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
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.
Any thoughts.?
Thanks,
Anil.
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?