About this task
These reports analyze the data in the datamart to check for tables that do not have Foreign Keys. They use the overview analyses (connection and catalog analyses) to compute the results.
You have accessed Talend DQ Portal as a user.
At least one report has been generated on a connection or catalog analysis in the Profiling perspective of Talend Studio.
To launch a report in order to list the tables that do not have Foreign Keys, do the following:
From the web user interface, click the icon, point to Reports
> Integrity reports and then click
Tables without FK.
ExampleThe corresponding page opens.
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.
- Click the Report explore icon to display a dialog box that lists some of the reports generated in the Profiling perspective of Talend Studio.
- From the Report list, select the overview report you want to analyze in order to check for any tables that do not have Foreign Keys.
Click Confirm at the bottom right corner
of the dialog box.
The name of the selected report appears in the Report field.
Click Execute in the top of the Parameters panel.
A loading indicator is displayed and then a TABLES WITHOUT FK report on the selected report opens in the page.
ExampleIn this example, the TABLES WITHOUT FK report is launched on a database content analysis. The results show how many tables in each schema in the database do not have Foreign keys. For example, in the crm catalog, the contact_tp and cust tables do not have Foreign Keys.
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.