About
The loading properties of an operator.
Articles Related
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) |