Navigator User Guide

Back Next

Creating a Data Map from an Extraction Map

You can create a PowerExchange data map from an extraction map.

For example, you might want to create a sequential data map with the same layout as a DB2 table or an Adabas table.

PowerExchange stores the data map in the current resource configuration directory on the local system.

To create a data map from an extraction map:

Open the extraction group, and open the extraction map.

Right-click the extraction map and click

Create Data Map

In the

Create Map

dialog box, enter the following information:

Schema Name: Enter the schema name, which PowerExchange uses as the first part of the data map name, as follows:

schema_name
.
map_name
Map Name: Enter the map name, which PowerExchange uses as the second part of the data map name, as follows:

schema_name
.
map_name
Include Capture Control Fields: Includes the following PowerExchange-generated columns in the data map:

DTL__CAPX
type

DTL__
columnname
_BI

DTL__
columnname
_CI

Clear this option to exclude these columns from the data map.

Default is selected.
Include Binary Count and Null Indicator Fields: Includes the PowerExchange-generated columns, DTL__
columnname
_CNT and DTL__
columnname
_IND, in the data map.

Clear this option to exclude these columns from the data map.

Default is cleared.

Click

PowerExchange saves the data map in the current resource configuration directory on the local system.