PowerCenter All Products
Suspend Workflow on Error
Suspends the workflow when a task in the workflow fails. You can fix the failed tasks and recover a suspended workflow.
Sends an email when the workflow suspends.
Enable HA Recovery
Saves the workflow state of operation in a shared location. You do not need high availability to enable workflow recovery.
Automatically Recover Terminated Tasks
Recovers terminated Session and Command tasks while the workflow is running. You must have the high availability option.
Maximum Automatic Recovery Attempts
The number of times the Integration Service attempts to recover a Session or Command task.
The recovery strategy for a Session or Command task. Determines how the Integration Service recovers a Session or Command task during workflow recovery and how it recovers a session during session recovery.
Fail Task If Any Command Fails
Enables the Command task to fail if any of the commands in the task fail. If you do not set this option, the task continues to run when any of the commands fail. You can use this option with Suspend Workflow on Error to suspend the workflow if any command in the task fails.
Output is Deterministic
Indicates that the transformation always generates the same set of data from the same input data. The Integration Service can resume a session from the last checkpoint when the output is repeatable and deterministic. When you enable this option with the Output is Repeatable option for a relational source qualifier, the Integration Service does not save the SQL results to shared storage.
Output is Repeatable
Indicates whether the transformation generates rows in the same order between session runs. The Integration Service can resume a session from the last checkpoint when the output is repeatable and deterministic.When you enable this option with the Output is Deterministic option for a relational source qualifier, the Integration Service does not save the SQL results to shared storage.