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

Card Puncher Data Processing

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





Discover More
Card Puncher Data Processing
Oracle Warehouse Builder

Owb Documentation - Understanding Data Quality Management White...



Share this page:
Follow us:
Task Runner