Selecting the table you want to analyze - 7.3

Talend Open Studio User Guide

Version
7.3
Language
English
Product
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for Data Quality
Talend Open Studio for ESB
Module
Talend Studio
Content
Design and Development
Last publication date
2023-10-11
Available in...

Open Studio for Data Quality

Procedure

  1. Expand DB Connections, browse to the table to analyze and select it.
  2. Click Finish to close the Create New Analysis wizard.
    Note: You can directly select the data quality rule you want to add to the current analysis by clicking the Next button in the New Analysis wizard or you can do that at later stage in the Analyzed Tables view as shown in the following steps.
    The analysis editor opens with the defined analysis metadata, and a folder for the newly created analysis is displayed under Analyses in the DQ Repository tree view.
  3. If required:
    • Click Select Tables to open the Table Selection dialog box and select new tables to analyze.

      You can filter the table or column lists by typing the desired text in the Table filter or Column filter fields respectively. The lists will show only the tables/columns that correspond to the text you type in.

    • Select another connection from the Connection list to connect to a different database. This list has all the connections created in Talend Studio. If the tables listed in the Analyzed Tables view do not exist in the new database connection you want to set, you receive a warning message that enables you to continue or cancel the operation.
  4. Right-click any of the listed columns in the Analyzed Columns view and select Show in DQ Repository view, the selected column is automatically located under the corresponding connection in the tree view.