You can run a database row test for a table in a personal metadata profile to preview data.
The PowerExchange Navigator allows you to select columns with datatypes that PowerExchange does not support. A database row test fails when you include columns with unsupported datatypes.
Open a personal metadata profile.
On the
Personal Metadata
tab in the
Resource Explorer
, double-click a table to open it.
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.
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.
The
Fetch
list is disabled. For a personal metadata profile, the default option is
Data
.
Optionally, edit the SQL SELECT or DTLDESCRIBE statement in the
SQL Statement
box.
If you selected the
CAPX
or
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
Go
.
The
Database Row Test Output
window displays the results of the database row test.