Creating a table analysis with a simple SQL business rule - 7.1

Talend Data Management Platform Studio User Guide

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
Talend Data Management Platform
task
Design and Development
EnrichPlatform
Talend Studio

You can create analyses on either tables or views in a database using SQL business rules. The procedure for creating such analysis is the same for a table or a view.

Prerequisite(s):
  • At least one SQL business rule has been created in the Profiling perspective of the studio. For further information about creating SQL business rules, see Creating an SQL business rule

  • At least one database connection is set in the Profiling perspective of the studio. For further information, see Connecting to a database.

In this example, you want to add the SQL business rule created in Creating an SQL business rule to a top_custom table that contains an age column. This SQL business rule will match the customer ages to define those who are older than 18.