PowerExchange Interfaces for PowerCenter

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

Back Next

Configuring PowerExchange Extraction Maps

To ensure enough information is passed through to PowerCenter for a column, or columns, intended for use as a target primary key, a “change indicator” and “before image” field must be associated with the PowerExchange extraction map.

To configure a PowerExchange extraction map:

To add the before image and change indicator, right-click the extraction group.

Open the extraction group.

Open the extraction map. Either right-click the map and select Open
, or double-click the extraction map.

Right-click the column that requires the before image and change indicator to be set.

Select Amend Control Indicator/Before Image Extensions.

To set the change indicator, select and add the required column by double-clicking or highlighting it and then clicking Add
.

When all the required change indicators have been set up, click the Before Images
tab.

Repeat the process for columns that require the before image to be included with the change capture data.

The BI and CI column names can be changed on these screens by single-clicking and editing. The following sections in this chapter will refer to the default names.

Rename Saved Search

Table of Contents

PowerExchange Interfaces for PowerCenter

PowerExchange Interfaces for PowerCenter

Configuring PowerExchange Extraction Maps

Configuring PowerExchange Extraction Maps