tELTOutput UPDATE operation example?

Anonymous — Fri, 10 Mar 2017 06:20:44 GMT

I have to create a new Talend job that updates values in target table. I implement this using ELT logic (a lot of rows -> better perfomance). Could you please describe how to implement this WHERE clauses part logic in Talend Open Studio (Component -> Basic Settings -> WHERE clauses ("Action on data" = "Update"). Didn't find any good examples online. As I am implementing it for PostgreSQL, the particular component in my job is "tELTPostgresqlOutput", but at this case I am more intrested in this update logic in general. So, I just need to see some good examples that I can adapt later to my particular cases.

Br,
Allikmaa.

Re: tELTOutput UPDATE operation example?

Anonymous — Mon, 13 Mar 2017 03:25:18 GMT

Hi,
What does your general update logic look like?
Usually, the " Action on data" option can be available in t<DB>output component. Could you please give us more information about your particular cases?
Best regards
Sabrina

topic Re: tELT<database>Output UPDATE operation example? in Talend Studio

tELTOutput UPDATE operation example?

Re: tELTOutput UPDATE operation example?