Navigator User Guide

10.5.4
- 10.5.6
- 10.5.5
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Testing an Extraction Map

You can run a database row test for an extraction map to preview captured change data and test changes to a capture registration.

Open an extraction group and an extraction map.

To get data for specific columns, select the columns in the

Extract Definition

window.

PowerExchange adds the selected columns to the SQL SELECT statement that is generated in the

SQL Statement

box in the

Database Row Test

dialog box.

Selecting specific columns in the table does not affect SQL DTLDESCRIBE requests.

Click

File

Database Row Test

The

Database Row Test

dialog box appears.

In the

DB Type

list, click the data source type. Then, enter any information that is associated with the data source type.

Select the

AS4_META

data source type only at the direction of Informatica Global Customer Support.

In the

Fetch

list, select

Data

to preview data, or select another option to preview metadata for an item such as a table or a schema.

The row test generates an SQL statement in the

SQL Statement

box based on the selected

Fetch

option:

For the

Data

option, the row test generates an SQL SELECT statement.

For a metadata option, the row test generates an SQL DTLDESCRIBE statement.

Optionally, edit the SQL SELECT or DTLDESCRIBE statement in the

SQL Statement

box.

If you selected the

CAPX

CAPXRT

access method, enter an application name in the

Application

box.

If you selected the

CAPX

CAPXRT

DB2390IMG

, or

NRDB

access method, click

Advanced

to enter override values for the row test. Then, in the

Advanced Parameters

dialog box, enter any of the available override values for the source type. These values override certain values in PowerExchange definitions or configuration files, such as data maps or the DBMOVER configuration file.

In the

Get n Rows

field, enter the number of rows that you want the row test to fetch. You can display up to 99999 rows of data at a time. By default, PowerExchange displays ten rows of data.

If you selected the

CAPX

CAPXRT

NRDB

, or

NRDB2

data source type and selected

Data

in the

Fetch

list, you can have the row test skip a specific number of initial rows before displaying data. To skip rows, specify a number from 1 to 99999 in the

Skip First n Rows

field.

Click

The

Database Row Test Output

window displays the results of the database row test, which show the changes that occurred on the table that you registered for data capture.

If you added before or after image columns to the extraction map, these columns also appear in the database row test output.

Rename Saved Search

Table of Contents

Navigator User Guide

Navigator User Guide

Testing an Extraction Map

Testing an Extraction Map