Table of Contents

Search

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

Mappings

Mappings

Template parameters

Template parameters

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.

0 COMMENTS

We’d like to hear from you!