A testing application set consists of a Procedure and an XML script and provides the ability to define a series of tests against data warehouse objects; either comparing them to an expected value or to the results of a query.

The XML script contains the test definitions. Each test is a new XML node in the XML script and contains a name, a test query, an expected value, or a comparison query.

The procedure simply runs the tests and determines whether the tests are passed or not. This is most likely to be run as a scheduled job within WhereScape RED.

  • No labels