Potential Primary Keys
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
-
From the user interface, click the
icon, point to Reports
> Integrity reports and then click
Potential PK.
The corresponding page opens.Example
-
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. -
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.