tThresholdViolationAlert Standard properties

Schema and Edit schema

A schema is a row description, it defines the number of fields to be processed and passed on to the next component. The schema is either Built-in or stored remotely in the Repository.

Built-in: You create and store the schema locally for this component only. For more information about a component schema in its Basic settings tab, see Basic settings tab.

Repository: You have already created the schema and stored it in the Repository and thus reuse it when needed. For more information about a component schema in its Basic settings tab, see Basic settings tab.

Output field

Select in the list the output field that will hold the input data.

Additional Information

When the Job is generated, this area is prefilled with detail information about the threshold violations in the selected report. It lists the values of the indicators which do not respect the thresholds. It also lists the report name, the analysis name and the analyzed element description (column name, table name and schema name).

This same information will be sent in the email message.

Advanced separator (for numbers)

Select this check box to change data separators for numbers:

Thousands separator: define separators you want to use for thousands.

Decimal separator: define separators you want to use for decimals.

Separator between Suffix and Field Value

Enter the separator that will delimit the field name from its value.

Field Separator

Character, string or regular expression to separate fields.

Row Separator

String (ex: "\n"on Unix) to separate rows.

tStat Catcher Statistics

Select this check box to collect log data at the component level.

Global Variables

MAILFIELD: the mail field storing the mail content to be sent. This is an After variable and it returns a string.

ERROR_MESSAGE: the error message generated by the component when an error occurs. This is an After variable and it returns a string. This variable functions only if the Die on error check box is cleared, if the component has this check box.

A Flow variable functions during the execution of a component while an After variable functions after the execution of the component.

To fill up a field or expression with a variable, press Ctrl+Space to access the variable list and choose the variable to use from it.

For more information about variables, see Using contexts and variables.

Usage rule

This component is used as an intermediate component in a Job design. It needs an input and output components. tThresholdViolationAlert only works with a MySQL database.