Mapping Specification Guide

Back Next

Adding an SQL Query

Add an SQL query to query the source or target data in a mapping specification.

From the Actions menu, click

SQL Query

The

SQL Query

wizard appears.

On the

Columns

panel, select a source or target column and click the arrow icon to add it to the

SQL Query

editor.

Optionally, enter an SQL Query in the

SQL Query

editor to modify the query.

Optionally, click the

Validate

icon to validate the SQL query.

Click

Run SQL Query

to run the SQL query.

Watch

Comments

0 COMMENTS

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