Partial Parameterization
You can define mappings and specify an Advanced filter for source objects, using parameters only for part of the configuration. For example, you might want to parameterize only one field or one of the values. With this type of partial parameterization, you can achieve these goals:
- •Create a string or field parameter and use it in an Advanced filter for a source, or in an Expression or Aggregator transformation.
- •Reuse a single parameter created in the source within other transformations, similar to an expression macro.
- •Allow users to select a specific field in the Mapping Configuration task, without writing a complete query.
In the source transformation Query Options dialog, the Parameters tab shows the parameters available in the transformation. From this dialog, you can create a new parameter or use those already defined.