Oracle CDC V2 Connector

Back Next

Advanced session properties in mapping tasks

When you create or edit a mapping task that processes change records from a PowerExchange CDC source, set some advanced session properties that pertain to CDC.

In the

Advanced Session Properties

section on the

Runtime Options

page, click

to add each advanced session property. The following table describes the advanced session property values to add:

Advanced Property	Required Value
Commit on End of File	No This setting avoids duplicate data from occurring on the target after a mapping task job is restarted. The default is No .
Recovery Strategy	Resume from last checkpoint This setting is the only valid value. It is required to enable the recovery of change data and CDC restart information on the target after a mapping task ends abnormally or is stopped before completing change data processing. With this setting, the mapping task can resume processing change data from the point of interruption in the change data stream. By default, recovery is disabled and the task status remains as Failed. If the task is included in a taskflow, the taskflow continues to run.

Advanced Property

Required Value

Commit on End of File

This setting avoids duplicate data from occurring on the target after a mapping task job is restarted. The default is

Recovery Strategy

Resume from last checkpoint

This setting is the only valid value. It is required to enable the recovery of change data and CDC restart information on the target after a mapping task ends abnormally or is stopped before completing change data processing. With this setting, the mapping task can resume processing change data from the point of interruption in the change data stream.

By default, recovery is disabled and the task status remains as Failed. If the task is included in a taskflow, the taskflow continues to run.

For information about other advanced session properties, see the topic "Advanced Session Properties" under Tasks > Data Integration Tasks in the Informatica Cloud

Data Integration

Help. The following advanced session properties are not supported or required for CDC:

$Source Connection Value

$Target Connection Value

Incremental Aggregation

Reinitialize Aggregate Cache

SQL ELT Optimization options

Session Sort Order

Cache LOOKUP() Function

Pre-build Lookup Cache

On Stored Procedure Error

Data Column Delimiter