Clarification on tDBOutput component

Anonymous — Sat, 16 Nov 2024 07:02:40 GMT

Hi,

Could you clarify on tDBOutput component.

In a job I wanted to read data joining 3 tables to populate data on 2 tables (on update).

I will have a tDBInput (select with data to populate master and history table).

This tDBInput will be connected to tDBOutput_1 where I wanted to update table1(primary key), only for the records that matches the primary key.

This will be followed by another tDBOutput_2 for update only for the records that matches the primary key.

Question is: tDBOutput for update table, will it match the primary key and update for the records that matches the primary. For unmatched records will it ignore or does insert?

Thanks

Re: Clarification on tDBOutput component

Anonymous — Fri, 14 Dec 2018 20:05:28 GMT

Hi,

In the below flow, I had kept the Action on data as Update and tried to add a new record with key value as "5".

But the flow ignored the new record and successfully completed.

So if you are trying to do both insert and update , i would suggest to appropriate "Insert or Update" or "Update or Insert" options so that records will not be skipped.

If the answer has helped you, could you please mark the topic as resolved? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi

topic Clarification on tDBOutput component in Talend Studio

Clarification on tDBOutput component

Re: Clarification on tDBOutput component