Informatica Connector Toolkit Getting Started Guide

Back Next

Test the Read Capability of the Connector

When you test the read capability of the connector, you test the connection definition, metadata of the data source, and operations that the connector supports. After you specify the test settings and run the test, you can view the result of the read operation, read operation statistics, and the log file.

To debug the code, use the same debug configuration that you used to test the connection and metadata components of the connector. You can also set breakpoints in the code that you want to debug.

After you define the debug configuration, you can launch the

Test Read

dialog box to test the read capabilities of the connector.

In the

Connector Progress

view, select the native metadata object that appears under

Test Read

The

Test Read

dialog box appears with the default JVM environment settings and tracing level. The Informatica Connector Toolkit uses the JVM settings to run the debug configuration.

If required, edit the JVM environment settings. Ensure that you use the same port number that appears in JVM settings for the connection properties in the debug configuration.

Select the required tracing level. The default is normal. Based on the amount of detail that you require in the log file, you can override the default tracing level.

You can set the following types of tracing level:

None: Does not override the default tracing level.
Terse: Logs initialization information and error messages and notification of rejected data.
Normal: Logs initialization and status information, errors encountered, and skipped rows due to transformation row errors. Summarizes mapping results, but not at the level of individual rows. This is the default tracing level.
Verbose Initialization: In addition to normal tracing, logs additional initialization details, names of index and data files used, and detailed statistics.
Verbose Data: In addition to verbose initialization tracing, logs each row. You can also get detailed statistics on where string data was truncated to fit the precision of a column.

Click

The connection attributes that you defined for the connector appears.

Enter values for the connection attributes to test the connection to the data source.

Click

Connect

The

Test Metadata

page appears with the metadata imported from the data source.

Select the native metadata objects and the corresponding native metadata fields to test the read operation.

Click

Based on whether the selected native metadata object supports join and filter operations, the

Join Condition

page or

Filter Condition

page appears.

If the native metadata object supports join operation, specify an expression in the

Join Condition

page.

To specify an Informatica platform expression for the join operation, perform the following steps:

In the

Definition

section, select the native metadata object for which you want to specify the join condition.

To change the join order, click

Move Up

Move Down

Specify the join type in

Join condition

To define a join condition, select values in the

Left Field

Operator

, and

Right Field

columns.

To add additional join conditions, click

Add

To remove a join condition, select the join condition and click

Remove

To specify a native expression for the join operation, enter the expression in the

Definition

section.

If the native metadata object supports filter operation, select the

Configure Filter

option in the

Filter Condition

page and specify the filter condition.

To specify an Informatica platform expression for the filter operation, perform the following steps:

In the

Definition

section, click

Add

to add an Informatica platform expression.

In the

Field

column, select the field to use in the expression.

In the

Operation

column, select a conditional operator to use in the expression.

In the

Value

column, enter a value for the conditional expression.

To specify a native expression for the filter operation, enter the expression in the

Definition

section.

After you specify expressions for the native metadata object, click

The

Read Capability

page appears.

Specify values for the read capability attributes and then click

Run

The

Result

page appears. You can view the result of the read operation, read operation statistics, and the log file in the

Result

page.

Click

Test the Read and Write Capabilities of the Connector

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

Back Next

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Informatica Connector Toolkit Getting Started Guide

Informatica Connector Toolkit Getting Started Guide

Test the Read Capability of the Connector

Test the Read Capability of the Connector