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. Export to PowerCenter
  13. Import From PowerCenter
  14. Performance Tuning
  15. Pushdown Optimization
  16. Partitioned Mappings
  17. Developer Tool Naming Conventions

Developer Mapping Guide

Developer Mapping Guide

Example. Expression Parameters in a Filter Condition

Example. Expression Parameters in a Filter Condition

Use expression parameters to parameterize the filter condition in a Filter transformation.
For example, you might use an expression parameter for a filter condition with the following default value:
EmployeeID > 100
The following image shows where you can configure the expression parameter:
This image shows the Filter tab of the Filter transformation, the New Parameter dialog box, and the Expression Editor where you can configure the expression parameter.
If the Filter transformation is reusable, you can bind the transformation parameter to a mapping parameter. You can assign a different default value to the mapping parameter and use the mapping parameter in non-reusable transformations in the mapping.
For example, you can edit the mapping parameter and configure the following default value:
Dept < 2000
The following image shows the default value of the mapping parameter:
This image shows the Parameter tab of the Properties view for the mapping. The Parameters tab shows the expression parameter with the default value Dept > 2000.

0 COMMENTS

We’d like to hear from you!