SmartMatch feature in Astera Centerprise adds to the reusability of the file source objects used in the flow documents (dataflows, workflows, and subflows). When the SmartMatch option is enabled, Centerprise checks for the specified alternate header values in a synonym dictionary file that is a part of the project.
How SmartMatch Option Works¶
Astera Centerprise looks for the alternate header values using a step-by-step approach. First, it looks for exact header match in the incoming source file and the object layout specified in the dataflow. Second, it checks for alternate headers in the field layout (as opposed to alternate headers in the synonym file).
Synonym Exact Match¶
If for any specific field, it is unable to find the exact header match, it then looks for the specified alternate header values in the synonym dictionary file.
Note: The Use SmartMatch with Synonym Dictionary option should be enabled for file sources for Centerprise to look for alternate header values in a synonym dictionary.
In a synonym dictionary file, it will look for exact variants first. For example, if the synonym file has an entry ShippingID=Shipping Number, Centerprise will read the data from the fields marked ShippingID and Shipping Number in the same way.
Synonym Token Match¶
You can also create tokens in a synonym dictionary file.
For example, if you define that ID = Number|Num|number|#
Centerprise will store the values defined as a token and use it to read the data wherever an exact header match is not found. Tokens are useful to handle layout differences in multiple header fields at once.
For instance, for the token created for ID, shown above, Centerprise will handle unmapped data fields as shown in the table below:
|Customer ID||Customer Number||Customer Num||Customer number||Customer #|
|Shipping ID||Shipping Number||Shipping Num||Shipping number||Shipping #|
|Order ID||Order Number||Order Num||Order number||Order #|
Compact String Match¶
If there are still unmapped fields, Centerprise will remove whitespaces and punctuation characters and attempt to match source and target.