tThresholdViolationAlert Standard properties - 7.1

Reporting

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
task
Data Governance > Third-party systems > Data Quality components > Reporting components
Data Quality and Preparation > Third-party systems > Data Quality components > Reporting components
Design and Development > Third-party systems > Data Quality components > Reporting components
EnrichPlatform
Talend Studio

These properties are used to configure tThresholdViolationAlert running in the Standard Job framework.

The Standard tThresholdViolationAlert component belongs to the Data Quality family.

This component is available in Talend Data Management Platform, Talend Big Data Platform, Talend Real Time Big Data Platform, Talend Data Services Platform, Talend MDM Platform and Talend Data Fabric.

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.

 

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: "\n"on Unix) to separate rows.

tStat Catcher Statistics

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

Global Variables

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

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.