Specify

Source

.

The default value is Target. The PowerCenter Integration Service automatically overrides the default to Source. Unless this value is Source, you cannot change

Commit On End Of File

.

Disable this option.

By default, this option is enabled and PowerCenter Integration Service performs a commit when the session ends. This commit occurs after PWXPC commits the restart tokens. As a result, duplicate data can occur on restart.

Select

Resume from the last checkpoint

. PWXPC requires this setting for recovery.

If you use PowerCenter high availability (HA) option, you must also specify the

Enable HA Recovery

option for the workflow.

If you use a transformation type for which the

Output is Deterministic

option is available, ensure that you select this option. If you use a Lookup transformation, select the

Lookup Source is Static

or

Lookup Cache Persistent

option instead. If you do not select one of these options, you cannot validate the CDC session in Workflow Manager.

The default value is

Fail task and continue workflow

.

Select

Normal

.

The default value is

Bulk

. To use recovery, you must select Normal.

Enter

1

to ensure target data and restart token integrity are maintained.

The default value is 0. With the default, any errors that the PowerCenter Integration Service encounters while writing to the target database or target files are not counted. Writer threshold errors can include key constraint violations, loading nulls into a not null field, and database trigger responses. In this case, PWXPC does not detect that the writer has not applied the data to the target and consequently advances the restart tokens.

Specify a unique name.

The default value is the first 20 characters of the workflow name. However, the default might not result in a unique name.

Specify a unique name.

The default is either the application name, or the workflow name if no application name is specified. However, the default might not result in a unique name.

Specify a value greater than 0.

The default is 0. With the default, PWXPC keeps only one backup copy of the restart token initialization and termination files. Specify a value greater than 0 to retain history for recovery purposes.