- PowerCenter 10.4.0
- All Products
Receives and passes the date entered.
Tests current value for DATE_ENTERED against the stored value for DATE_ENTERED in the variable port, PREV_DATE.
Receives the value for DATE_ENTERED after the Integration Service evaluates the NEW_DATE port.
Passes the flag from NEW_DATE to the Transaction Control transformation.
The Integration Service evaluates ports by dependency. The order in which ports display in a transformation must match the order of evaluation: input ports, variable ports, output ports.
IIF(NEW_DATE = 1, TC_COMMIT_BEFORE, TC_CONTINUE_TRANSACTION)