Creating a PowerExchange Capture Registration and Extraction Map for an Oracle Source

Creating a PowerExchange Capture Registration and Extraction Map for an Oracle Source

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.
  1. Open the extraction group that corresponds to the registration group that you created.
  2. Open an extraction map that corresponds to a capture registration that you created.
  3. Click
    File
    Database Row Test
    , or click the
    Row Test
    button on the toolbar.
    The
    Database Row Test
    dialog box appears.
  4. 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.
  5. 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.
  6. 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.
  7. 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.
  8. In the
    Application
    field, enter any value.
  9. 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.

0 COMMENTS

We’d like to hear from you!