tThresholdViolationAlert - 6.1

Talend Components Reference Guide

EnrichVersion
6.1
EnrichProdName
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for Data Quality
Talend Open Studio for ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
task
Data Governance
Data Quality and Preparation
Design and Development
EnrichPlatform
Talend Studio

Warning

This component will be available in the Palette of Talend Studio on the condition that you have subscribed to one of the Talend Platform products.

Warning

This component is only usable with the report database (MySQL) that stores the results of the analyses executed in the studio. For information on the report database, see the report chapter in Talend Studio User Guide.

tThresholdViolationAlert properties

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: "\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 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

Related scenarios

No scenario is available for this component yet.