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. Related topic: see

Talend Studio User
Guide.

Repository: You have already
created the schema and stored it in the Repository and thus reuse it
when needed. Related topic: see
Talend Studio User
Guide.

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: ”
“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 further information about variables, see
Talend Studio

User Guide.

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.