Run a validation check batch

You must run validation checks as a batch.

1. Go to Study Manager > Validation Checks tab.
2. Select a validation check batch and click the Submit Job icon.

   Tip:

   The Submit Job icon does not appear if the validation check batch is not installed. Check the Installed Status.

   If the installation status of a validation check batch is Warning, you may still be able to run the batch. Check the installation log file. If the status is Warning because one of the source tables is not used in the current study, the batch runs without input from that table.

3. Enter values:

   • Submission Mode: Select one:

     • Full mode processes all records.

     • Incremental mode processes only new and changed records.

       Note:

       Oracle DMW can load validation checks (or direct transformations) quickly when done incrementally. To do this, Oracle DMW automatically generates your MAP package with additional code. For example, you may see lines with the following format in your MAP program:

       If ( execution mode = 'fast incremental' ) then
       --- modified logic
       Else
       ---original logic
       End if:

   • Force Execution: Select to run the job even though the source data currency, parameter values, and the version number of the program(s) have not changed since the last run. The system uses Full mode regardless of the Submission Mode setting. Full mode includes data deletion.

     If not selected and all the conditions are the same as the last run, the system does not execute the job and returns a status of Success.

   • Submission Type: Select:

     • Immediate to run the job once, as soon as possible.

     • Scheduled to set up a regular schedule.

     • Deferred to run the job once, at a future time.

   • Trigger Downstream Transformations and Validation Checks: Select this checkbox if you want the system to detect all transformations and validation checks set up for this data model and all others that come after it, and submit them sequentially.

     Note:

     This option appears only if the validation check batch is set up to allow it.

   • Click the Refresh icon at any time for an update.

   • To check the log file, click the icon in the Log column.