Performing a Database Row Test with the Extraction Map
Performing a Database Row Test with the Extraction Map
Perform a database row test on the extraction map that is associated with the capture registration that you created. The row test verifies that the extraction map can be used to access change data in an Oracle source table.
Perform the row test before you import the extraction map into PowerCenter and create a source definition for a CDC session.
Open the extraction group that corresponds to the registration group that you created.
Open an extraction map that corresponds to a capture registration that you created.
Click
File
Database Row Test
, or click the
Row Test
button on the toolbar.
The
Database Row Test
dialog box appears.
In the
DB Type
list, select
CAPXRT
. This setting allows you to preview data directly from the source table, rather than from the PowerExchange Logger log files.
In the
Location
list, select the node name that you specified for the PowerExchange Listener on the Oracle source system.
This name must be specified in a NODE statement in the local dbmover.cfg file and in the
Location
field for the registration group. This scenario uses the name of pwx961.
In the
UserID
and
Password
fields, verify that your Oracle user ID and password are displayed.
These values match the
UserID
and
Password
values that you entered for the registration group.
In the
Fetch
list, select
Data
to preview data.
The row test will display a SELECT statement for the registered table in the
SQL Statement
box.
In the
Application
field, enter any value.
Click
Go
.
The
Database Row Test Output
window displays rows of the changes that occurred on the source table, if any. The following image shows example output:
The row test results include the generated DTL__ columns that PowerExchange adds to extraction maps. These columns contain CDC-related information, such as the SQL change type and time stamp. When you import the extraction map into Designer, the PowerExchange Client for PowerCenter (PWXPC) includes the PowerExchange-generated columns in the source definition.