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.