Table of Contents

Search

  1. Preface
  2. Change Data Capture Introduction
  3. PowerExchange Listener
  4. PowerExchange Condense
  5. DB2 for i5/OS Change Data Capture
  6. Remote Logging of Data
  7. Introduction to Change Data Extraction
  8. Extracting Change Data
  9. Monitoring CDC Sessions
  10. Managing Change Data Extractions
  11. Tuning CDC Sessions
  12. Appendix A: DTL__CAPXTIMESTAMP Time Stamps

CDC Guide for i5/OS

CDC Guide for i5/OS

Extraction Maps

Extraction Maps

An extraction map is a definition of a change data extraction for a source table.
PowerExchange generates an extraction map when you create a capture registration. You can edit the generated extraction maps to add or remove columns. You can also create additional extraction maps for a capture registration, each for a subset of the columns that are registered for capture. In the PowerExchange Navigator, extraction maps are listed under the extraction group for the database instance and node location from which the data is extracted.
To define a data source in PowerCenter, you can import the extraction map. When you run a CDC session, PowerExchange uses the source definition for extracting change data.

0 COMMENTS

We’d like to hear from you!