Extraction maps are generated by the PowerExchange Navigator when you create a capture registration for a source. If necessary, you can modify an extraction map or create another extraction map based an existing capture registration.

When you import an extraction map in PowerCenter Designer, select the

CDC Datamaps

option in the

Import from PowerExchange

dialog box. Designer then creates the source definition based on the extraction map. The

Metadata Extensions

tab for the source definition shows the schema name and map name imported from the extraction map. You do not need to specify this information in the session properties.

Alternatively, you can import source metadata from a relational database to define source definitions. However, you must then manually specify the extraction map name in the session

Properties

to use a CDC reader and an application CDC connection.

If you want to extract change data from a multi-record nonrelational source with extraction maps, you must create a PowerExchange capture registration for every table in the data map. For each registration, the PowerExchange Navigator creates a corresponding extraction map. You can then either import the data map as a multi-record nonrelational source (for batch usage) or import the extraction map for each table (for CDC usage).