Table of Contents

Search

  1. Preface
  2. Mappings
  3. Parameters
  4. CLAIRE recommendations
  5. Data catalog discovery
  6. Visio templates

Mappings

Mappings

Configuring a Visio template

Configuring a Visio template

Configure a Visio template in the
Cloud Integration Template Designer
to define flexible, reusable data flow logic for use in
mapping
tasks.
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
mapping
tasks.
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
mapping
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
mapping
task. You associate a parameter file with a
mapping
task.
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
    mapping
    task.