Smart Mapper
Smart Mapper provides the ability to intelligently determine how data is to be mapped in the activity's input tab. Smart mapper provides functionality to match the source element and target element by comparing various parameters such as names, data types, depth, cardinality, and element ancestors.
The smart mapper has the following options on the Basic tab:
Field | Description |
---|---|
Element Mapping Options |
|
Automap fields above threshold(%) | The threshold value is the minimum value to qualify for element matching. For more number of matches, lower this value, and for more accurate selection, increase the threshold value.
The default value for the Match with Similar Names option is 70% and for the Match with Exact Names option is 90%. Clear the checkbox to customize this value. |
Source matching level | Level up to which the mapper must look for a matching element from the selected source element for dragging.
The supported range is 1 to 10. The default value is 4. Warning: Increasing this value might create memory related issues based on machine configuration and recursiveness of the schema.
|
Target matching level | Level up to which the mapper must look for a matching element from the to-be-dropped target element.
The supported range is 1 to 10. The default value is 4. Warning: Increasing this value might create memory related issues based on machine configuration and recursiveness of the schema.
|
Restore Default | Restores all the values to default in the Basic tab. |
The smart mapper has the following options on the Advanced tab:
Field | Description |
---|---|
Linguistic Weight(%) | It focuses more on the similarity in names, rather than its data type, ancestor, or cardinality. Increasing the value maps more similar named elements even when the other parameters such as datatype, cardinality, or ancestor names do not match.
Similarly, reducing the value to give lesser priority to the similarity of the names of the element, and more to the other parameters based on their settings. The value ranges from 0.0 to 100.0. The default value for the Match with Similar Names option is 50.0 and for the Match with Exact Names option is 100.0. |
Type Weight(%) | Type weight focuses on the data type similarity of the elements, which means increasing type weight considers the data type of the elements in priority to other parameters like similarity in name (linguistic weight, cardinality etc.).
The value ranges from 0.0 to 100.0. The default value for the Match with Similar Names option is 25.0 and for the Match with Exact Names option is 0.0. |
Ancestor Weight(%) | It focuses on ancestor names of the potential candidates from source and target elements. When set to zero, it does not consider the ancestor name of the element.
When set to 100, it checks the value of the Linguistic Weight, and gives equal weight to the ancestor name matching. The value ranges from 0 to 100. The default value for the Match with Similar Names option is 50 and for the Match with Exact Names option is 0. |
Ancestor Weight Degradation | If you clear this checkbox, ancestors at any level have the same priority while considering ancestor similarity.
If you select this checkbox, the smart mapper gives priority to the parent element, then its ancestor and so on. By default, for the Match with Similar Names option, the checkbox is selected and for the Match with Exact Names option, the checkbox is clear. |
Level Difference Weight(%) | It decides the priority to be given to the difference in levels of an element in a complex schema. Increasing the value considers the difference in level more than other parameters. It checks for levels of source and target elements in the schema. When you increase this value, it tries to search matching elements in the same level and vice versa.
The value ranges from 0.0 to 100.0. The default value for the Match with Similar Names option is 10.0 and for the Match with Exact Names option is 0.0. |
Cardinality Weight(%) | It considers the cardinality of the element. If its value is set to zero, it does not consider the cardinality at all. If you increase its value, it considers the cardinality more than the other parameters.
The value ranges from 0.0 to 100.0. The default value for the Match with Similar Names option is 25.0 and for the Match with Exact Names option is 0.0. |
Restore Default | Restores all the values to default in the Advanced tab. |
If there is already an existing mapping and then you apply smart mapping. The following user-created structures persist and other mappings are overwritten:
Coercion
Choice conditions
Variables
Constants
statement with functions
For Each statements
To obtain better mappings, increase or decrease the values and tune the parameters as per your requirements.
After performing a smart mapping operation, if some of the simple-type target elements are not matched, right-click the target element and select Recommended Mappings.
A list of elements is displayed that are possible close matches of the target element.
The recommended elements are based on the mapping option selected or the parameters tuned in the custom mapping.
The following attributes of the matching source elements are displayed:
- Parent Element - Name of the immediate parent of the recommended source element
- Source Element - Name of the recommended source element
- Type of Element - Data type of the recommended source element
- Mapping Score % - The rating of the recommended source element to the selected target element
If the recommended mappings are not as per your requirements, you can manually map the elements. Smart mapper remembers this manual mapping.
The next time you perform a smart mapping on the same schema, the smart mapper tries to map the same elements used in the manual mapping. This functionality is applicable only for that workspace.
If you have manually mapped an incorrect element during smart mapping and do not want the smart mapper to record this particular mapping choice, you can simply delete the mapping.
Alternatively, replace the current mapping with the desired element. This replaces the element recorded by the smart mapper.
If you no longer want the smart mapper to record your manual mapping choices, you can clear the Record user mapping selections checkbox from the Mapper preference dialog.