OWB - Operator Loading Properties

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

1 - About

The loading properties of an operator.

3 - Update: Operation

You can specify an update operation to be performed when Warehouse Builder locates a matching row and updates the target. An update operation is performed on the target attribute using the data of the source attribute. Table: Update Operations lists the update operations you can specify and describes the update operation logic. Update Operations

Operation Example Result If Source Value = 5 and Target Value = 10
= TARGET = SOURCE TARGET = 5
+= TARGET = SOURCE + TARGET TARGET = 15 (5 + 10)
-= TARGET = TARGET - SOURCE TARGET = 5 (10 - 5)
=- TARGET = SOURCE - TARGET TARGET = negative 5 (5 - 10)
||= TARGET = TARGET || SOURCE TARGET = 105 (10 concatenated with 5)
=|| TARGET = SOURCE || TARGET TARGET = 510 (5 concatenated with 10)
Advertising