Navigator User Guide

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

Back Next

Testing a Data Map

You can run a database row test to validate a data map and preview data for the tables in a data map.

A database row test accesses data in a data source and displays it in table format in the

Database Row Test Output

window.

Open a data map.

On the

Data Map

tab in the

Resource Explorer

, click a table.

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

Table

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.

This setting does not affect SQL DTLDESCRIBE requests.

Click

File

Database Row Test

The

Data Map Remote Node

dialog box appears.

Enter connection information for the remote system and click

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

NRDB2

, or

IMSUNLD

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