tThresholdViolationAlert – Docs for ESB 5.x

Component family

Data Quality

Function

tThresholdViolationAlert can
alert to any threshold violations regarding the thresholds set on
indicators in different analyses created in the Profiling perspective of the
Studio.

Purpose

tThresholdViolationAlert
communicates with the report database that stores the analysis
results. It scans the report database looking for the thresholds
that are violated in the column analyses in the selected report. You
can then use it with other components in the job, for example
tSendMail, to alert to any
threshold violations regarding the thresholds set on indicators used
in the column analyses.

In order not to create such a job manually from scratch, you can
generate a ready-to-use job that uses tThresholdViolationAlert from the Profiling perspective of the Studio.
For further information, see the report chapter in Talend Studio User Guide.

Basic settings

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.

Since version 5.6, both the Built-In mode and the Repository mode are
available in any of the Talend solutions.

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 settings

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

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.

Limitation

n/a