You are viewing archived documentation for Data Trust v2024.06 (previous version).
Go to the latest v7.6 documentation →

Data Trust › Scenario Studio › Scenario Builder

Validation using Negative Check Business Rule

Validate that all numeric values in a column are negative.

Overview

The Negative Check business rule validates that numeric values in a specified column are all negative (less than zero). It is used to detect data entry errors where sign conventions are expected to be consistently negative.

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.
• An RDBMS connection has been configured and the target column contains numeric data.

Steps

Path: Data Trust › Scenario Studio › Scenario Builder › Validation using Negative Check Business Rule

Figure 1: Validation Option - Copy

Navigate to the Scenario Studio module and select the Validation using Negative Check Business Rule option from the left sidebar or main menu. This opens the scenario builder canvas where you will configure the data source connections, transformation rules, and execution settings.

Figure 2: Validation Option

Navigate to the Scenario Studio module and select the Validation using Negative Check Business Rule option from the left sidebar or main menu. This opens the scenario builder canvas where you will configure the data source connections, transformation rules, and execution settings.

Figure 3: Drag and drop RDBMS Widget - Copy

Drag the Rdbms Widget - Copy 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 4: Drag and drop RDBMS Widget

Drag the Rdbms 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 5: Select Connection and click on Navigator

Select the appropriate connection from the dropdown to link this widget to its data source. Choosing the correct connection profile ensures the scenario reads from or writes to the intended database or file system.

Figure 6: Select table - Copy

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 7: Select table

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 8: Click on 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 9: Drag and drop Negative Value Check

Drag the Negative Value Check 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 10: Business Rule

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 11: Click onAdditional Settings Tab

The Additional Settings panel provides advanced configuration options such as custom SQL filters, join conditions, and performance tuning parameters. Configure only the settings relevant to your scenario — leave optional fields at their default values unless a specific behaviour is required.

Figure 12: Drag and drop Email Widget

Drag the Email 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 13: Configure Email

The Email widget sends an automated result notification to configured recipients after the scenario finishes executing. Provide the recipient addresses, subject, and choose whether to attach the exception report or include a summary in the email body.

Figure 14: Click on Execute Button

Click the Execute button to trigger the scenario and begin processing data from the configured sources. The scenario transitions to Monitor mode where you can track real-time execution progress and view interim results as each step completes.

Figure 15: Validation Executed

Click the Execute button to trigger the scenario and begin processing data from the configured sources. The scenario transitions to Monitor mode where you can track real-time execution progress and view interim results as each step completes.

Figure 16: Validation Execution Summary Page

The Validation Execution Summary Page 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.

Figure 17: Recived Email

The Email widget sends an automated result notification to configured recipients after the scenario finishes executing. Provide the recipient addresses, subject, and choose whether to attach the exception report or include a summary in the email body.