Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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