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

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

Anonymous — Sat, 16 Nov 2024 02:58:08 GMT

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.

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

Anonymous — Tue, 17 Mar 2020 00:41:27 GMT

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

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

manodwhb — Tue, 17 Mar 2020 02:54:19 GMT

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

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

Anonymous — Tue, 17 Mar 2020 12:40:42 GMT

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

Thanks,
Anil.