After PowerExchange Express CDC for Oracle is running, you might need to add a capture registration for another Oracle table.
In PowerExchange Navigator, create the capture registration.
Make sure that you include the following settings:
In the
Condense
list, select
Part
.
In the
Supplement Log Group Name
box, enter a name for the supplemental log group for the table. The PowerExchange Navigator generates DDL for creating the supplemental log group. If you select
Execute DDL now
, the PowerExchange Navigator runs the DDL when you complete the registration. If you do not have the authority to run the DDL, ask your DBA to run it.
In the
Status
list, select
Active.
Run the DDL for a creating a supplemental log group for the table, if you did not enable the PowerExchange Navigator to do so at registration completion.
If you use the PowerExchange Logger for Linux, UNIX, and Windows, shut down the PowerExchange Logger and then warm start it.
The PowerExchange Logger begins capturing change data for the additional table.
In PowerCenter, import the extraction map for the table to create a source definition.
Add the source definition to a new mapping or to an existing mapping.
If you add the source definition to an existing mapping, you must the stop the workflow first.
Start the workflow that processes the added source table.