Use Mapping Architect for Visio to create mapping templates using Microsoft Office Visio. A mapping template is a drawing that represents a PowerCenter mapping. You can configure rules and parameters in a mapping template to specify the extraction logic. Mapping Architect for Visio is installed with the PowerCenter Client.This listing demonstrates the use of a Visio template to generate mappings that can perform a specific transformation based on the source data type before loading into the target. The Mapping Template automates the following aspects of the mapping logic using template parameters.

1. Copy and connect the source columns to different transformations based on data type.
2. Apply specific transformation like RTRIM, LTRIM to all fields in an expression.
3. Create a sequence generator and connect it to target.

You can download this listing as part of the Bundle : Visio Templates.