Update selected columns in a table using tOracleOutput
Hi, I have a table row with the following values. I need to update only a certain value in the table. Can this be achieved using tOracleOutput insert or update action. I am fetching data from a tMap component. Current Row: NULL | N | NOTICE | 10 (Primary key column at the end) The record tMap gives is: ABC | N | NULL | 10 What I need is: ABC | N | NOTICE | 10
Re: Update selected columns in a table using tOracleOutput
Hi, Based on your keys for joining you ensure that you take only the the columns you wanna update are from lookup flow. And the rest of the columns should be remapped with main flow data in the tmap. In this way you can update only the fields you want to update.