If you want PowerExchange to perform field-level processing on some records in a Db2 source table, you must use a data map.

For example, in some Db2 environments, a table can contain a single column that stores an array of fields in a format that is not consistent with the column datatype, such as a CHAR or VARCHAR column that stores multiple packed data fields. You can use an expression to modify this data before PowerCenter replicates it to a target. Also, if you add a user-defined field to a table in record view, you can build an expression to populate it. In the PowerExchange Navigator, you can define expressions only for data maps.

You might have data maps available for your source tables if you used PowerExchange bulk data movement to materialize your data targets. Bulk data movement requires data maps. You can use the bulk data maps for CDC if you merge them with the extraction maps for your data sources. The PowerExchange Navigator automatically generates an extraction map when you create a capture registration. Alternatively, you can manually add an extraction map.