Navigator User Guide

10.5.1
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Adding Columns to or Removing Columns from Extraction Processing

You can edit an extraction map to add columns to or remove columns from extraction processing.

Adding or removing columns from extraction processing does not affect the columns in the associated capture registration for which PowerExchange captures change data.

You can also associate DTL__CI and DTL__BI columns with columns in the extraction map. A change indicator (DTL_CI) column indicates whether the contents of the column changed in a change record. A before image (DTL__BI) column contains the contents of the column from before the last update operation.

Open the extraction group.

Open the extraction map.

The

Extract Definition

window displays column metadata on the following tabs:

The

Map

tab displays metadata for the columns for which PowerExchange captures change data and any DTL__CI and DTL__BI columns that you added to those data columns. The tab also displays the metadata for the PowerExchange-generated columns if you choose to show these columns.

To show the PowerExchange-generated columns, right-click anywhere in the

Map

tab and click

Show Auto Generated Columns

The

Extensions

tab displays CI and BI columns if they are added for one or more extraction map columns.

To remove a column from extraction processing, clear the check box next to the column name.

PowerExchange stops extracting change data for the removed columns but continues extracting data for the selected columns.

To add a column to extraction processing, select the check box next to the column name.

After adding or removing columns, verify that the extraction map is still valid by running a database row test on it.

Extraction Groups and Extraction Maps