panel to configure the SQL transformation. When you configure the transformation, you specify the transformation name and description, configure fields and field mapping, and specify the type of SQL that the transformation processes. You also set the advanced properties for the transformation.
The following image shows the
Properties
panel of an SQL transformation that is configured to process a stored procedure:
Configure the transformation using the following tabs on the
Properties
panel:
General
Configure the SQL transformation name and optional description.
Incoming Fields
Define field rules that determine the data to include in the transformation.
Not applicable to unconnected SQL transformations.
SQL
Define the database connection and the type of SQL that the transformation processes: either a stored procedure, stored function, or query.
If you configure the transformation to process a stored procedure
or stored function
, you select the stored procedure
or stored function
on this tab.
If you configure the transformation to process a stored procedure, you can choose to run the transformation as an unconnected transformation.
If you configure the transformation to process a user-entered query, the SQL editor appears on this tab. Enter the query in the SQL editor.
Input Fields
For transformations that process stored procedures, displays the stored procedure input
fields.
You can edit the
Precision
and
Scale
metadata fields for relational connections
or ODBC connections that use stored procedures.
Field Mapping
For stored procedure and stored functions, specify how to map incoming fields to the input fields of the selected stored procedure or function.
You do not configure the field mapping for queries or unconnected SQL transformations.
Output Fields
For stored procedures
and stored functions
, displays a preview of the SQL transformation output fields. For user-entered queries, configure output fields for the columns retrieved from the database.
For queries, the output fields also include the SQLError field, the optional NumRowsAffected
field, and optional pass-through fields.
You can edit the
Precision
and
Scale
metadata
fields for relational connections or ODBC connections that use stored
procedures.
Advanced
Define advanced properties for the transformation. Advanced properties differ based on the type of SQL that the transformation processes.
Field name conflicts must be resolved in an upstream transformation. You cannot use field name conflict resolution rules in an SQL transformation.
ASK INFAPreview
