Mapping templates are divided into the categories: Integration, Cleansing, Warehousing

, and Industry Solutions

.

The following image shows some of the mapping templates in the New Asset dialog box:

When you select a mapping template in the

New Asset

dialog box, you create a mapping that uses a copy of the mapping template.

The template mapping contains pre-populated transformations. Click on each of the transformations in the mapping to see the purpose of the transformation, how the transformation is configured, and which parameters are used.

The following image shows the Augment data with Lookup template with the Source transformation selected. The

Description

field shows how the Source transformation is configured:

You can use a mapping template as is or you can reconfigure the mapping. For example, the Augment data with Lookup template uses the p_scr_conn parameter for the source connection. You can use the parameter to specify a different connection each time you run the

mapping

task that uses this mapping. You might want to use the same source connection every time you run the

mapping

task. You can replace the parameter p_scr_conn with a specific connection, as shown in the following image:

When you save the mapping, you save a copy of the template. You do not modify the template itself.

You can copy a template mapping to advanced mode.

Mapping templates don't apply to mappings in SQL ELT mode.