Table of Contents

Search

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

Mappings

Mappings

Template parameter usage

Template parameter usage

Visio template parameters are flexible placeholders that you can use in many different ways. Some examples:
  • Output field. You can use a template parameter to define a field.
    In the following example, $fullname$ is an output field that merges first and last name data from the source:
    $fullname$ = CONCAT(fname,lname)
  • Expression clause. You can use a template parameter as part of a larger expression.
    For example, you might use the following in a WHERE clause:
    fullname=$nameexpr$
    Or, in the following example, the unit price template parameter and quantity template parameter define the TOTAL output field.
    TOTAL=$unitpricefield$*$quantityfield$
    You might create a template parameter for a filter condition as follows:
    $filter$
    Or, use a template parameter to represent a field in a filter condition:
    NOT ISNULL($id$)
    You might create a lookup condition using two template parameters as follows:
    $lookupID$=$sourceID$
    You could use a template parameter in a link rule as follows:
    $custid$ (to) CUST_ID
  • Expressions. If you configure a template parameter to use the field mapping input control, you can configure an entire expression or sets of expressions. With the field mapping input control, you can use any input field in expressions.