Configure mapping object properties in a mapping template the same way as you configure the mapping object properties in a mapping. When you create a mapping template from a mapping and you view the mapping object properties, you see the values you configured in the Designer for the mapping object. If you change the transformation properties in the mapping template and import the mapping template into the Designer, you see the values you configured in Mapping Architect for Visio.

Configure the mapping objects to apply to all the mappings that you plan to create from the mapping template. Specify a name or use a parameter for each mapping object, except for source and target definitions. Specify a rule set name for each link in the mapping template. Property names, property values, parameter names, and parameter values are case sensitive unless otherwise noted.

You may want to use parameters to handle different settings for transformations in multiple mappings. For example, you can use a parameter in the SQL query of a source qualifier. When you configure the source qualifier in the mapping template, set the value of the property to a parameter:

In the mapping template parameter file, set the value of the parameter to the SQL statement appropriate for the mapping:

Or, you can include a parameter when you set the SQL query:

In the mapping template parameter file, set the value of the parameter to the source table name:

To configure a mapping object in the mapping template, double-click the mapping object in the drawing window.