Table of Contents

Search

  1. Preface
  2. Part 1: Introduction
  3. Part 2: PowerExchange Client for PowerCenter (PWXPC)
  4. Part 3: PowerExchange ODBC
  5. Appendix A: PowerExchange Interfaces for PowerCenter Tips
  6. Appendix B: Datatypes and Code Pages
  7. Appendix C: PowerExchange Interfaces for PowerCenter Troubleshooting

PowerExchange Interfaces for PowerCenter

PowerExchange Interfaces for PowerCenter

Editing an Extraction Map Definition

Editing an Extraction Map Definition

You can edit extraction maps to make minor changes to them, for example:
  • Modify a column datatype.
  • Modify the owner name.
  • Add or delete columns.
  • Add a description of the extraction map.
  • Create metadata extensions.
When you use extraction maps, you do not need to add the DTL__CAPXACTION field nor do you need to include an Update Strategy transformation. PWXPC will automatically include the DTL__CAPXACTION column in its SELECT statement for CDC sources. It then uses the value of the DTL__CAPXACTION to construct the appropriate SQL statement (INSERT, UPDATE, or DELETE).
Changing column information in the extraction map could result in failures in the session or workflow during the extraction process.

0 COMMENTS

We’d like to hear from you!