You can define the update strategy for active Java transformations. To define the update strategy, use the
Defines Update Strategy
option on the
Advanced
tab.
You can define the update strategy at the following levels:
Within the Java code
You can write the Java code to set the update strategy for output rows. The Java code can flag rows for insert, update, delete, or reject. To define the update strategy with in the Java code, enable the
Defines Update Strategy
option and use the setOutRowType method in the On Input Row section of the Java editor to flag rows. For more information about setting the update strategy, see
setOutRowType.
Within the Target transformation
You can configure the Target transformation to set the update strategy. To configure the Target transformation to set the update strategy, disable the
Defines Update Strategy
option and configure the target operation in the target properties.
This option does not apply to passive transformations.