Potential Primary Keys - 7.2

Talend Data Quality Portal User and Administrator Guide (deprecated)

EnrichVersion
7.2
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
EnrichPlatform
Talend DQ Portal
task
Data Governance
Data Quality and Preparation

About this task

These reports analyze the data in the datamart using the following simple statistics indicators: row count, distinct count, unique count and duplicate count. They check which columns could be used as Primary Keys.

Prerequisite(s):
  • You have accessed Talend DQ Portal as a user.

  • At least one report has been generated in the Profiling perspective of Talend Studio on a column analysis that uses the simple statistics indicators.

To launch a report in order to locate the columns that can be used as Primary Keys, do the following:

Procedure

  1. From the user interface, click the icon, point to Reports > Integrity reports and then click Potential PK.
    The corresponding page opens.

    Example

  2. Click in the Header field and select YES if you want to insert a logo in the report to launch.
    The default logo file is a Talend logo, but you can decide to use a logo of your choice. For further information, see Customizing logos in reports.
  3. Click the Report explore icon to display a dialog box that lists some of the reports generated in the Profiling perspective of Talend Studio.
  4. Select the report you want to analyze in order to check for any columns that can be used as Primary Keys.
  5. Select the report you want to generate and then click Confirm at the bottom right corner of the dialog box.
    The name of the selected report appears in the Report field.
  6. Click in the top right corner of the page.
    A loading indicator is displayed and then a POTENTIAL PRIMARY KEYS report is open in the page.

    Example

    In this example, the POTENTIAL PRIMARY KEYS report is launched on the column_client report already generated in the Profiling perspective of Talend Studio. The results show that one column in the client table can be used as Primary Key.
  7. In the top right corner of the page, click to save the report parameters.
    You can run a saved report without redefining its parameters, for further information, see Accessing the list of defined reports.