A Visio template includes at least one source definition, source qualifier, target definition, and links that define how data moves between objects. A Visio template can include other Informatica objects, such as a Lookup object to define lookups or a Joiner object to join heterogeneous sources.
A pipeline consists of a source qualifier and all the objects and targets that receive data from the source qualifier. You can include one or more pipelines in a Visio template.
When you configure a Visio template, you can configure template parameters. Template parameters are values that you can define in
In a Visio template, sources, targets, and lookups are always template parameters. You can create additional template parameters for other data flow logic, such as filter or join conditions or other expressions.
You can use expression macros in Expression and Aggregator objects. Expression macros allow you to define dynamic expression logic.
You can also use user-defined parameters in Visio templates and
tasks. User-defined parameters are values that you define in a parameter file. You can update user-defined parameter values without editing the Visio template or the
task. You associate a parameter file with a
When you configure a Visio template, you can configure the following:
Source and target objects to be used in the task.
Data flow logic. To perform data transformation add the appropriate objects, such as an Expression object to configure expressions.
Links and rules. Create links between objects and link rules to define how data moves between objects.
Template parameters. Use template parameters for values that you want to define later in the process. Sources, targets, and lookups are always template parameters. Create additional template parameters as necessary.
Expression macros. (Optional.) If your data flow includes Expression or Aggregator objects, you can use expression macros to enable flexible expression logic.
User-defined parameters. Configure user-defined parameters for values that you define outside of the Visio template or