PowerCenter
- PowerCenter 10.4.0
- All Products
Port Name
| Expression
| Description
|
---|---|---|
DATE_ENTERED | DATE_ENTERED | Input/Output port. Receives and passes the date entered. |
NEW_DATE | IIF(DATE_ENTERED=PREVDATE, 0,1) | Variable port. Tests current value for DATE_ENTERED against the stored value for DATE_ENTERED in the variable port, PREV_DATE. |
PREV_DATE | DATE_ENTERED | Variable port. Receives the value for DATE_ENTERED after the Integration Service evaluates the NEW_DATE port. |
DATE_OUT | NEW_DATE | Output 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)