Preface
Understanding Mapping Architect for Visio
Mapping Templates
Mapping Objects
Mapping Template Rules
Using the Import Mapping Template Wizard
Using the mapgen Command Line Program
Using Informatica Mapping Templates
Glossary
- Mapping Architect for Visio Glossary of Terms

Mapping Architect for Visio Guide

10.4.0
- 10.5.7
- 10.5.6
- 10.5

Back Next

Understanding the Mapping

The following figure shows a mapping that the Remove Duplicates Mapping Templates Wizard creates when you select the Remove Duplicates option:

The mapping contains a source, source qualifier, the SRT_GetData Sorter transformation, the AGG_RemoveDuplicateRecords Aggregator transformation, and a target.

The Remove Duplicates Dimension mapping uses the Sorter transformation, SRT_GetData, to sort the data. The Aggregator transformation, AGG_RemoveDuplicateRecords, removes the duplicate records and passes only one version of the data to the target table.

You can create the following transformations by using the Remove Duplicates Mapping template:

Sorter transformations

Aggregator transformations

Remove Duplicates Template

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal