Db2 for i CDC Connector > Mappings and mapping tasks with Db2 for i CDC Connector > Mapping configuration

Mapping configuration

You must configure a mapping that contains a Source transformation for a Db2 for i CDC source and map it to a Target transformation.
To begin creating a mapping in Data Integration, click New > Mappings > Mapping and then click Create.
A mapping must contain at least one Source transformation mapped to one Target transformation. Alternatively, a mapping can contain multiple Db2 for i CDC sources and multiple targets. For example, you can define multiple one-to-one mappings, map one source to multiple targets, or map multiple sources to one target. To map multiple sources to the same target, you can create multiple one-to-one mappings that map each source separately to the same target. In this case, each source must have a different primary key value.
Important: If you include multiple CDC sources in a mapping, all of the Source transformations must use the same Db2 for i CDC connection, which connects to the same PowerExchange Listener and source location.
A mapping can also contain other transformation types, such as a Joiner transformation or Lookup transformation, as needed. If you include a Lookup transformation, make sure that you select either the Lookup Source is Static or Lookup Cache Persistent advanced property for the transformation. Otherwise, any associated mapping task for which the Recovery Strategy advanced session property is set to Resume from last checkpoint, as recommended, will fail.
When you define a Source transformation in a mapping, specify a name for the transformation, a Db2 for i CDC connection that can connect to the PowerExchange Listener on the PowerExchange Logger system, the source type, and the extraction map for the Db2 for i CDC source object. You can also set some additional source properties. The PWX CDC Metadata Adapter retrieves metadata for the source table from the PowerExchange extraction map, including the field definitions.
When you define a Target transformation, specify a name for the transformation, a connection to the target, the target type, and the operation type of Data Driven. In the user's environment, the target can reside on premises or in a cloud. If you do not want to send all of the incoming fields to the target, you can define one or more exclusion field rules. As part of configuring the target, you must also map the incoming fields to the target fields. You can map fields automatically based on the field names or manually map them.
Instead of selecting specific connections and objects in the Source and Target transformations, you can define a parameter for the connection, the source or target object, or both. You then must enter a specific connection or object in the associated mapping tasks. If you want to use a parameter for the source or target connection, you must perform one of the following actions before the mapping can be successfully validated:
You can also completely or partially parameterize field mappings, and then define specific mappings in the mapping tasks.

Db2 for i CDC source properties in mappings

When you create a mapping, you configure a Source transformation for a Db2 for i CDC source and set some source properties for the Source transformation.
Click the Source transformation box on the mapping canvas. Then configure the source properties in the Source Properties panel below the mapping canvas.
If you have multiple Source transformations in a mapping, configure source properties for each source. If you use a specific connection instead of a connection parameter, enter the same connection for all sources.
The Properties: Source panel contains the following tabs on which you can enter information:
Note: Ignore the Partitions tab. Key-range partitioning is not supported for CDC connections.

Targets in mappings with Db2 for i CDC sources

To configure a target in a mapping, click the Target transformation box on the mapping canvas. Then configure the target properties in the Target Properties panel below the mapping canvas.
Note: To determine which target types are supported by Db2 for i CDC Connector, see Supported targets.