For a DB2 source, you can merge a data map with an extraction map.
For example, if a source table contains columns in which you store data in a format that is inconsistent with the column datatype, you can create a data map to manipulate that data with PowerExchange expressions. If you store packed data in a CHAR column, you might create a data map to manipulate and prepare that data for loading to a target. You can then merge the data map with an extraction map. The extraction map uses the associated data map to map the change data.
Open the extraction group.
Open the extraction map.
On the
Extraction Group
tab in the
Resource Explorer
, right-click the extraction map and select
Amend Capture Registrations
.
In the
Extract Definition - Amend Capture Registrations
dialog box appears, select
Merge
.
In the
Bulk Datamap Name
box, enter a data map name or select a data map:
Click the Browse button to browse to the file.
In the
DB2 Datamaps Selection
dialog box, specify filter criteria under
DB2 Map Filter Data
to restrict the list of data maps. You can include wildcards.
Click
Next
.
In the
Available Datamaps
list, select a data map and click
Finish
.
Click
OK
.
The extraction map uses the associated data map to map the change data. The merged data map appears in the