Clarification on tDBOutput component

[Anonymous]

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

[Anonymous · Accepted solution]

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