Preface
Mappings
Mapplets
Mapping Parameters
Where to Assign Parameters
Mapping Outputs
Generate a Mapping from an SQL Query
Dynamic Mappings
How to Develop and Run a Dynamic Mapping
Dynamic Mapping Use Cases
- Use Case: Dynamic Mapping for Metadata Changes in Relational Sources
- Use Case: Reuse Dynamic Mapping for Different Sources and Targets
Mapping Administration
Export to PowerCenter
Import From PowerCenter
Performance Tuning
Pushdown Optimization
Partitioned Mappings
Developer Tool Naming Conventions

Developer Mapping Guide

10.5.4
- 10.5.6
- 10.5
- 10.4.0

Back Next

Parameters in Filter and Join Conditions

You can assign a parameter to the SQL statement that you add to the filter or join condition. You can assign the parameter in a customized data object read operation; or in a relational data object in a Read transformation.

The following image shows where you can assign a SQL parameter to a filter or join condition:

This image shows the Query tab in the Properties view. The Query tab includes properties to configure SQL statements for the following conditions: Hints, Join, Filter, and Sort.

When you edit the join or the filter condition, you can use a parameter to specify the condition.

For example, the following image shows the dialog box that you can use to assign a parameter to the SQL statement when you edit the filter condition:

This image shows the dialog box Filter Query. In the dialog box, Parameter is selected for the property Specify By. Under the property Specify By, you can choose to create a new parameter or browse for a parameter.

Rename Saved Search

Table of Contents

Developer Mapping Guide

Developer Mapping Guide

Parameters in Filter and Join Conditions

Parameters in Filter and Join Conditions