Mapping input to output elements automatically

Use the Auto map wizard (automap) to automatically create Move transforms from input to output elements based on some correlation of the names of input and output elements to create mappings.

The following steps describe how to map from input to output elements by using the Auto map wizard:

1. In the Graphical Data Mapping editor, select the input and output elements that you want to map.
   • If you make no selections, the entire input and output objects in the current mapping level are processed by the Auto map wizard.
   • You can select groups of simple elements or complex elements. For complex elements, the descendants of the selected complex element can be mapped.
2. Click the Auto map icon.
   The Auto map wizard opens.
3. Choose the appropriate Mapping scope option:
   • Map all simple descendants of the selected elements. This option maps the descendants of the input element to the descendants of the output element that match each other; this option is selected by default. Optionally, select Group transforms into nested maps. For more information about using nested maps, see Grouping transforms into nested maps.
   • Map the immediate children of the selected elements. This option maps only the immediate child elements of the input element to the immediate child elements of the output element that match each other.
4. Specify how names are matched in the Name Matching Options section.
   1. Select the Case sensitive option to set whether you want to match the case sensitivity of the name. This option is not selected by default.
   2. Select the Alphanumeric characters (Letters and digits only) option to exclude special characters (for example & and - ) from the name. This option is selected by default.
   These two options are independent of each other, and you can select their values separately.
5. In the Mapping Criteria section, specify the mapping criteria for the matches between the input and output element names:
   • Create transforms when the names of inputs and outputs are the same. This option matches items of the same name, and is selected by default.

     Whether the two names are considered to be the same, depends on your selections for Case sensitive and Alphanumeric characters (Letters and digits only). For example, if you use the default options for Case sensitive and Alphanumeric characters (Letters and digits only), GIVEN_NAME and GivenName are considered to be a match. However, if you select Case sensitive and Alphanumeric characters (Letters and digits only), the two names are considered to be identical only if they contain the same alphanumeric characters in the same order, and the characters are of the same case.

     For more information, see Mapping by same name.

   • Create transforms when the names of inputs and outputs are more similar than. With this option, you can specify how similar two names must be to create a mapping between them by varying the result from zero to 100 percent. The result is displayed and the default value is 60; see Examples of similarity values for some examples of how similar words are matched to one another.

     For more information, see Mapping by similar name.

   • Create transforms when the input and output names are matched to synonyms defined in a file. With this option, you can create mappings for word pairs that are defined in a synonym file. A synonym file is a flat text file with file extension .txt or .csv. For further information about creating a synonym file from a Microsoft Excel spreadsheet, see Creating and using a synonym file.

     For more information about the synonym file, see Format of the synonym file. For information about the methods that are used to match synonyms in a synonym file, see Algorithm used to match synonyms.

   If the input and output names that you are using satisfy more than one of the following options, the order in which names are matched is:

   1. Same
   2. Synonym
   3. Similar

   Any output that is matched during an earlier step is excluded from name matching in a later step.
6. Click Finish to start the auto mapping, or click Next to view a summary of the transforms that were found and to choose the transforms that you want to create. You can clear matches that are defined on the summary page.
   Sometimes an input might match to more than one output; use the summary page to review and choose which mappings to create.
   The auto mapping is performed, and the selected matched input and output elements are mapped through Move transforms. Each auto mapped Move transform is annotated to indicate that it was created as a result of auto mapping. Hover the mouse or right-click the annotated transform to accept or reject the automatically created transforms.