Table of Contents

Search

  1. Preface
  2. Mappings
  3. Mapplets
  4. Mapping Parameters
  5. Where to Assign Parameters
  6. Mapping Outputs
  7. Generate a Mapping from an SQL Query
  8. Dynamic Mappings
  9. How to Develop and Run a Dynamic Mapping
  10. Dynamic Mapping Use Cases
  11. Mapping Administration
  12. Import From PowerCenter
  13. Performance Tuning
  14. Pushdown Optimization
  15. Partitioned Mappings
  16. Developer Tool Naming Conventions

Developer Mapping Guide

Developer Mapping Guide

Parameters in Filter and Join Conditions

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.

0 COMMENTS

We’d like to hear from you!