Creating a table analysis with an SQL business rule in a shortcut procedure - Cloud

Talend Cloud API Services Platform Studio User Guide

author
Talend Documentation Team
EnrichVersion
Cloud
EnrichProdName
Talend Cloud
task
Design and Development
EnrichPlatform
Talend Management Console
Talend Studio

About this task

You can use a simplified way to create a table analysis with a predefined business rule. All what you need to do is to start from the table name under the relevant DB Connection folder.

Prerequisite(s):

  • At least one SQL business rule is created in the Profiling perspective of the studio.

  • At least one database connection is set in the Profiling perspective of the studio.

For more information about creating SQL business rules, see Creating an SQL business rule.

To create a table analysis with an SQL business rule in a shortcut procedure, do the following:

Procedure

  1. In the DQ Repository tree view, expand Metadata > DB Connections, and then browse to the table you want to analyze.
  2. Right-click the table name and select Table analysis from the list.
    The New Table Analysis wizard is displayed.
  3. Enter the metadata for the new analysis in the corresponding fields and then click Next to proceed to the next step.
  4. Expand Rules > SQL and then select the check box(es) of the predefined SQL business rule(s) you want to use on the corresponding table(s).
  5. Click OK to proceed to the next step.
    The table name along with the selected business rule are listed in the Analyzed Tables view.
  6. Save the analysis and press F6 to execute it.

    An information pop-up opens to confirm that the operation is in progress and the analysis editor switches to the Analysis Results view.