OWB - How can i setup a simple UPDATE in a mapping ???

> Data Integration Tool (ETL/ELT) > Oracle Warehouse Builder

UPDATE target
SET col1 = col2 + col3 * 0.01

Here is de Demo.

Of here is the note :

  • In the target table property set the loading type to update.
  • You must set the col1 properties with : Load Column when Update to Yes
  • You must set the col2 and col3 properties with Load Column when Update to Yes