A provision to enable system recommend rules in a validation scenario

You are viewing documentation for Data Trust v7.6 (latest).
Looking for the previous version? View v2024.06 documentation →

Data Trust › Scenario Studio › Scenario Builder

Enable System Recommend Rules in a Validation Scenario

Let the system analyse data and suggest applicable validation rules.

Overview

A Validation scenario applies business rule checks to a dataset to ensure it meets defined quality criteria. Rules include Duplicate Check, Null Check, Range, Pattern, Referential Integrity, and custom SQL-based rules. This guide walks through building a validation scenario from data source selection to execution.

Note: Ensure all required connection profiles are configured in the Administration module before building this scenario.

Prerequisites

• You are logged in to Data Trust with a Pro-User or Admin Pro-User role.
• At least one connection profile has been configured and the target table or query is accessible.

Steps

Path: Data Trust › Scenario Studio › Scenario Builder › Enable System Recommend Rules in a Validation Scenario

Figure 1: Scenario Builder

This step involves interacting with the Scenario Builder within the Enable System Recommend Rules in a Validation Scenario workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.

Figure 2: drag and drop an RDBMS Table widget

Drag the An Rdbms Table Widget from the widget palette and drop it onto the scenario canvas. Positioning the widget opens its configuration popup where you will set the connection, table, and any additional options.

Figure 3: Read data from Table pop-up window

The Read data from Table pop-up window dialog exposes all available configuration options for this step. Review each field carefully and fill in the required values before clicking Save or OK to apply the configuration.

Figure 4: Navigator slide screen is displayed

The Navigator panel displays the available databases, schemas, and tables for the selected connection. Expand the tree to locate the required table or view, then click Select to add it to the widget configuration.

Figure 5: Click the Validation Rules tab

The Validation Rules tab lists all available business rule widgets that can be applied to the selected dataset. Drag the required rule widget onto the canvas, configure its threshold or pattern, then save before moving to the next step.

Figure 6: Drag and drop the Rules Recommendation

Drag the The Rules Recommendation from the widget palette and drop it onto the scenario canvas. Positioning the widget opens its configuration popup where you will set the connection, table, and any additional options.

Figure 7: Rules Recommendation pop-up window

The Rules Recommendation pop-up window dialog exposes all available configuration options for this step. Review each field carefully and fill in the required values before clicking Save or OK to apply the configuration.

Figure 8: Rules Recommendation in progress

This step involves interacting with the Rules Recommendation in progress within the Enable System Recommend Rules in a Validation Scenario workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.

Figure 9: Rules Recommendation Completed

This step involves interacting with the Rules Recommendation Completed within the Enable System Recommend Rules in a Validation Scenario workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.

Figure 10: toaster message Rules Created Successfully

This step involves interacting with the toaster message Rules Created Successfully within the Enable System Recommend Rules in a Validation Scenario workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.

Figure 11: the validation scenario is Failed

This step involves interacting with the the validation scenario is Failed within the Enable System Recommend Rules in a Validation Scenario workflow. Follow the on-screen prompts to complete this step before proceeding to the next configuration stage.

Figure 12: Validations Scenario Exceptions

The Validations Scenario Exceptions page presents the full outcome of the scenario execution including record counts, match rates, and any detected exceptions. Drill into exception records to inspect individual mismatches and use the Export to CSV option to share results with stakeholders.