CDC Transaction stage overview

You can use the CDC Transaction stage in an IBM® InfoSphere® DataStage® job to read data that is captured by IBM InfoSphere Change Data Capture (InfoSphere CDC) and apply the change data to a target database.

To use the CDC Transaction stage, you first set up replication in the InfoSphere CDC Management Console, and then use the InfoSphere CDC Management Console to generate a template for the InfoSphere DataStage job. You import the template into InfoSphere DataStage and modify the job, as required.

A basic CDC Transaction stage job includes the following stages and links:

A CDC Transaction stage that specifies details about accessing your installation of InfoSphere CDC.
The following output links from the CDC Transaction stage:
- An output link for each table in the subscription. These output links transfer change data from InfoSphere CDC to another stage or to a target database. If a subscription contains more than one table, the changes for each table can follow a different path through the job.
- A bookmark link that transfers bookmark information to a bookmark table in the target database.
Additional stages, as required, that process the data.
A database connector stage that specifies details about the target database.

For example, the following basic job contains a CDC Transaction stage, an output link, a bookmark link, and a DB2 connector stage that defines the details of the target database where the change data is applied:

Basic job that includes a CDC Transaction stage, an output link, a bookmark link, and a DB2 connector stage.

A more complex job might include additional stages that process the data before it is delivered to the target database. For example, you can create jobs that perform the following types of actions:

Transform change data by using prebuilt stages that are provided by InfoSphere DataStage
Integrate data by performing lookups
Apply custom business logic to the change data before delivering the data to a target database