Skip to main content

Vaildation Rules And Notification

Steps to create validation rules

  1. Create one or more queries (standard/advanced/aggregate/transform) for validation purpose.

  2. Right click on the data flow screen to find Validation Rule option. You can also add a validation rule from the data panel to the left.

  3. The dialog below will open when the validation rule option is selected

  4. The drop down list will show all queries. Select the query name designed for validation. Record number is the Minimum number of records to mark the query as failure. By default, it is one record. The message on failure and message on success are the messages you want to display on failure or success. Each validation rule may have multiple validation queries.

  5. Click on Run to executed the selected queries in the specified order. When a validation rule is run, it returns false if any of the validation query has failed. In addition, it returns a HTML text in the bottom pane with the failure message and failed records.

  6. Click on Save to save the rule.

  7. In the left hand side Data panel, right-click Export Templates and select New Template from the shortcut menu.

  8. In the Data Export wizard, you must first create a Destination Connection. From the list of available connectors, click to select the type of data connector you wish to use. Destination connections are set up in the same way as source data connections.

  9. Follow the wizard to find the Validate/Notify task.

  10. Select the drop down list to display all the validation rules defined in the Digital Process Logic pack. This is optional. By default no rule is selected.

  11. Optionally you may specify the validation output filename. %FPDIR% stands for Digital Process Logic pack directory. This output file contains the result of the validation rule in HTML. This HTML file will be emailed as an attachment.

  12. In addition, you can optionally specify the email address to send the result of the export. Click on Test Email to check if the email is delivered correctly.

  13. Click on Next.

  14. Click on Run export to start the export. If the validation rule is selected it will be run and if the rule returns false the export fails. An success or failure email will be sent if the notification was specified.