Update selected columns in a table using tOracleOutput

Five Stars

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

Here is the image of my job:
Four Stars

Re: Update selected columns in a table using tOracleOutput

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

Re: Update selected columns in a table using tOracleOutput

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

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.