OWB - INSERT IN A X COLUMN

[Kioutie]

Hi, This is my problem: i have a source table that have 3 fields:

id,
column_name,
column_value.

The problem is that i have to do, using OWB, an update of a target table with the information of my source table.
In pl/sql it would be easy to do an update of a variable field but how can i map it in OWB?
On each line of my source table, i don't know which field will have to be update, so i can't just link it from the source table to the target table!!

I can't modify the generated code, they dont want me to..

Thanks..

 

[zephan]

Hi,
open your mapping, select your target table, right click, select operator properties and change loading type property to 'Update'. Is it what you want to do ?
Regards,
Zephan