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.
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
