Database Validation

Definition

Configure a set of rules to ensure SQL Query results conforms to expected values.

Configuration

Validations

  • [Enable/Disable]: If checked, the database validation will be included in the validation process.
  • AND/OR
    • AND: All validation rules must be valid.
    • OR: One of the validation rules must be valid.
  • COLUMN: Select the data-set column to compare result with the criteria.
  • [Is/Is Not]
  • OPERATOR: See Data-Filter Operators 
  • CRITERIA: The string value to compare the result to.

 

Sample Result to Validate

This area contain the grid representation of an execution result. The default value displayed is the latest task’s result. You can display a previous result, if available, using the Right-Click menu item “Previous Results”. You can also use this area to add validation rules. Right-Click a value you want as the VALUE for your validation, then select “Add Validation”.