Redshift table is not working as two target instances in talend job(one for insert and other for update)

[Anonymous]

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.

[Anonymous]

below is the screenshot when job used target tables as Redshift tables

[manodwhb]

@aannamaneni , as part of testing if you keep one redshift table ,is that job working perfectly?

[Anonymous]

Yes.It worked fine with one table. Another test case also worked fine too
with one table and one file as target.

Thanks,
Anil.