Auto Mapping Classifiers and Features

Auto mapping enables you to automatically map source and target classifiers or source and target features. Auto mapping saves the effort of manually mapping the classifiers or features.

You can

Auto Map by Name Match.
Auto Map by Name Rule.

Auto Map by Name Match

This option enables you to automatically map the source and target classifiers or the source and target features that have the same names. It is case insensitive.

To auto map by name match,

If you are on	Steps to Auto Map by Name Match
ClassifierMap Designer	In the toolbar, click Auto Map by Name Match icon (). A pop-up window appears. Select the source schema from the drop-down list, and click OK.
FeatureMap Designer	In the toolbar, click Auto Map by Name Match icon ().

The status bar displays the number of classifiers or features that are mapped after auto mapping is complete.

Auto Map by Name Rule

This option enhances auto mapping by enabling you to apply name rules, and map the source and target classifiers or source and target features that do not have the exact names but similar.

To auto map by name rule,

If you are on	Steps to Auto Map by Name Match
ClassifierMap Designer	In the toolbar, click Auto Map by Name Rule icon (). A pop-up window appears. Select the source schema from the drop-down list. Click Next. The Auto Map Settings window appears.
FeatureMap Designer	In the toolbar, click Auto Map by Name Rule icon ( ). The Auto Map Settings window appears.

In the Auto Map Settings window,

You can select Case Sensitive to match the names based on case.
You can select Ignore Name Qualification (only on FeatureMap Designer ) to map data items that are on different levels in the hierarchical structure. For example, consider the following source and target structures:
Source Target
Name
Address
— Country
— State
Name
Country
State
Here the name qualifications of the source data items are ignored and Address.Country and Address.State are mapped to Country and State in the target.
Note: If there are multiple occurrences of the data item in the source, then the first occurrence of the unmapped data item in the current order will be mapped to the target.
You can select the options in the Ignore drop-down list for the Source and Target classifiers or features and enter the required information in the adjacent box.

The following table provides details about the various options that are available when using Auto Map by Name Rule.

Option	Description	Example
String(s)	Using this option, you can ignore one or more strings while auto-mapping. You must enter the string(s) in double quotes and separate it using a comma. This format applies only for the String(s) option. *Note:* This format is not allowed in releases prior to Data Exchange 5.0.	Example 1: To map, address[1] to address_1 address[2] to address_2 Choose the option “String(s)” in the Ignore drop-down list for the source as well as the target, and enter the following strings in the adjacent text box. At the source: “[”,“]” At the target: “_” Example 2: To map, Ispec_person to person Ispec_personId to personId Ispec_age to age Ispec_title to title Choose the option “String(s)” in the Ignore drop-down list for the source and enter “Ispec_” in the adjacent text box.
String starting with	Using this option, you can ignore a string starting with a particular string.	To map, Person to person_exported personId to personId_exported age to age_exported title to title_exported Choose the option “String starting with” in the Ignore drop-down list for the target and enter _ in the adjacent text box.
String ending with	Using this option, you can ignore a string ending with a particular string.	To map, Ispec_person to person Ispec_personId to personId Ispec_age to age Ispec_title to title Choose the option “String ending with” in the Ignore drop-down list for the source and enter _ in the adjacent text box.
First (…) character(s)	Using this option, you can ignore sub-strings of a specified length from the beginning of a string.	To map, Ispec_person to person Ispec_personId to personId Ispec_age to age Ispec_title to title Choose the option “First (…) character(s)” in the Ignore drop-down list for the source and enter 6 in the adjacent text box.
Last (…) character(s)	Using this option, you can ignore sub-strings of a specified length from the end of a string.	To map, Person to person_exported personId to personId_exported age to age_exported title to title_exported Choose the option “Last (…) character(s)” in the Ignore drop-down list for the target and enter 9 in the adjacent text box.
String by Regular Expression	Using this option, you can ignore sub-strings that match a particular Regular Expression.	To map, Person1 to Person Person20 to Person Person300 to Person Title1 to Title Title20 to Title Title300 to Title Choose the option “String by Regular Expression” in the Ignore drop-down list for the source, and enter \d in the adjacent text box to ignore the numbers.

The status bar displays the number of classifiers or features that are mapped after auto mapping is complete.