how to get updated rows id in tOracleOutput

Anonymous — Thu, 20 Sep 2018 15:10:15 GMT

Hi,
I am using tpostgresqlinput -> tmap -> tOracleOutput, can any one please let me know how to get ids of updated rows in order to have a log file with all modified rows.
Thanks & Regards,

Re: how to get updated rows id in tOracleOutput

Anonymous — Thu, 20 Sep 2018 19:15:08 GMT

Hi,

You cannot get the ids directly from tOracleOutput to get the ids of updated rows.

You can plan for an update trigger which will populate the details to log table. But trigger is not a recommended approach if there are lot of updates happening in the table.

Another way is to do a quick look up of the data before loading to the table. But do not use a traditional way of lookup where you will join the input data as main and the table where you need to verify as lookup connection. If the lookup table is having millions of records, it may take lot of time.

You can first load the input data to a temp table using Talend. Join the temp table and the target table within DB based on PK (if available) or other columns which will help you to identify row uniqueness. All matched columns are update candidates for your log table for further tracking.

If the reply has helped you, could you please mark the topic as resolved. Kudos are also welcome.

Warm Regards,

Nikhil Thampi

topic how to get updated rows id in tOracleOutput in Talend Studio

how to get updated rows id in tOracleOutput

Re: how to get updated rows id in tOracleOutput