Update selected columns in a table using tOracleOutput

[Anonymous]

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

Here is the image of my job:

[Anonymous]

row1.NOTICE_Column==NULL?NOTICE:row1.NOTICE_Column
Try similar to above
Vaibhav

[Anonymous]

This is sort of a specific solution. Actually I am trying to find out a generic solution to merge.

[Anonymous]

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.