Automatically mapping input to output elements

Use the Auto map wizard to map complex types by examining the names of input and output elements to create mappings.

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 are processed by the Auto map wizard.
2. Click the Auto map icon.
   The Auto map wizard opens to enable you to map based on the name of the element.
3. Choose the appropriate option from the Automatically map inputs to outputs wizard:
   • 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. See Grouping transforms into nested maps for more information about using nested maps.
   • Map the immediate children of the selected elements. This option maps only the immediate children of the input element to the immediate children of the output element that match each other.
4. After selecting either the Map all simple descendants of the selected elements or Map the immediate children of the selected elements option, specify how names are matched in the Name Matching Options section.
   These two options are independent of each other, and you can select their values separately:
   • Case sensitive. This option enables you to select whether you want to match the case sensitivity of the name; this option is not selected by default.
   • Alphanumeric characters (Letters and digits only). This option excludes special characters (for example & and - ) from the name; this option is selected by default.
5. In the Mapping Criteria section, specify the mapping criteria between the inputs and outputs:
   • 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 have used 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 have selected Case sensitive as well as 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.

     See Mapping by same name or similar name for further information.

   • Create transforms when the names of inputs and outputs are more similar than. This option allows you to specify how similar two words have to 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 Sample similarity values for some examples of how similar words are matched to one another.
   • Create transforms when the input and output names are matched to synonyms defined in a file. This option allows you to 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. See Creating and using a synonym file for further information about how you create a synonym file from a spreadsheet written in Microsoft Excel.

     See Format of the synonym file for further information about the synonym file itself, and Algorithm used to match synonyms for further information about the methods that are used to match synonyms in a synonym file.

   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.