Analyzing Results

The Analyze Results page displays the generated nested Boolean match rule, and potential match key components learnt from the information provided by you. The match rule can be reviewed and exported to the match rules repository of Match Rules Management option in the Enterprise Designer; this can further be consumed in your batch jobs. The potential match key components can be used in the Match Key Generator stage of the Enterprise Designer after reviewing.

Match Rule Tab

This tab is divided into two sections:
  • The left pane displays the match rule. On expanding the Rule, you can view all the conditions and sub-conditions.
  • A preview of these conditions is displayed in a tabular format on the right pane of the screen. It shows these details:
    • An Attribute such as Threshold, Scoring Method, Algorithms, and Missing Data Method.
    • Value for each of these attributes.

After reviewing the generated match rule, you can export it to the match rule repository by clicking the button. A pop-up window is displayed, specify a Rule Name and click Save.

The rule is saved and can be viewed in the Match Rules Management option of the Enterprise Designer.
Note: The Smart Data Quality (SDQ) is integrated with the Business Steward Module (BSM), which helps you improve the match rules based on the exception handling done in BSM. When you save the manual updates to the records in the BSM, it reflects as a notification on the Projects page in SDQ, corresponding to the project you made modifications to.
Note: Finally, the Business Steward Portal Data Quality page provides information regarding trends across data flows and stages.

Match Key Tab

This tab displays potential match key components in a tabular format. It also displays the Column in which the match key component was detected along with the Algorithm to be used. You can review and choose to consume any of the potential match key components based on your scenario by adding these in the Match Key Generator stage of Enterprise Designer.
Note: As of now, only the Substring algorithm is supported.
Example: This table displays a potential match key- Match Key 1 detected in the phone column. The algorithm to be used is SUBSTRING (1, 7), where 1 is the starting index, and 7 is the last index to be specified in the options of the Match Key Generator stage. The starting index is fixed to 1 for all potential match key components.
Match Key Column Algorithm
Match Key 1 phone SUBSTRING (1, 7)

Based on the actions performed by you : Variations present in the sample data uploaded, Columns selected for matching , and Records Tagged, the system has unlocked patterns present in your data to provide you with a match rule and potential match key components. It is suggested to test the generated results on your dataset.