About the Exception Transformation

The Exception transformation provides a user interface to find exceptional conditions or anomalies in the data. The Exception transformation is invoked from within a job.

Note: You can set up the Exception transformation in a new job or you can include the Exception transformation in an existing job.

After adding the Exception transformation to a job, right-click the transformation. This action provides access to its properties and to various other functions such as creating an exception definition or selecting a supplied exception definition.

The Exception transformation enables you to organize and describe how to examine the input source table to specify the conditions that are indicative of exceptional behaviors within the IT infrastructure. When exception jobs run and the criteria of exception definitions are satisfied, the Exception table is created. If specified, the exception condition table is also created. These tables can be used for processing at a later time.

In addition, an overview report is generated, along with individual reports for each exception that is discovered. These reports are optional, and if specified, they are published to the SAS Content Server and can be viewed in ITRM Report Center. (The Group By variables that are specified in the exception definition are used as BY variables for accessing reports in ITRM Report Center.)

Note: An exception job with one or more exception definitions always generates an overview report. However, if no exceptions are found, no individual reports are generated.

Exception Transformation Diagram