A template parameter is a placeholder for a value or values in a Visio template. You configure template parameters when you configure Informatica objects in the Visio template data flow.
You can define the value of the template parameter when you upload the Visio template to your
Data Integration
organization or when you create a
mapping
task based on the Visio template.
You can create a template parameter for any logical aspect of a data flow. Sources, targets, and lookups are always template parameters. You can create additional template parameters for other aspects of the data flow logic. Some template parameters you might want to create include the following:
Source filter in a source qualifier
Filter condition in a Filter object
Join condition in a Joiner object
Update strategy condition in an Update Strategy object
Expression in an Expression object
Expression in an Aggregator object
Link rule for a link
For example, if you have regional lookup data in different lookup tables, you might create a $lookuptable$ template parameter in the Lookup object that represents the lookup table. When you configure the
mapping
task, you select the lookup connection and table that you want to use. You configure a different
mapping
task for each regional lookup table.
To create a template parameter in a Visio template, surround the template parameter name with dollar signs as follows: $<template_parameter_name>$. Template parameter names are case sensitive.
By default, the template parameter name displays as the template parameter label in the
mapping
task wizard. However, you can also configure a template parameter label in the template or after you upload the template.
You can use the Show Parameters button on the Informatica toolbar to see the template parameters defined using the $<template_parameter_name>$ syntax. If you do not use the template parameter name syntax to configure source, target, or lookup template parameters, they do not display in the Show Parameters dialog box.