-
Click Analyzed Column Sets to display the
corresponding view.
In this example, you want to match the foreign keys in the customer_id column of
the sales_fact_1998 table with the primary keys in the customer_id column of the
customer table, and vice versa. This will explore the relationship between the
two tables to show us for example if every customer has an order in the year
1998.
-
From the Connection list, select the database
connection relevant to the database to which you want to connect.
You have in this list all the connections you create and centralize in the
Talend Studio
repository.
-
Click A Column Set to open the Column Selection dialog box.
If you want to check the validity of the foreign keys, select the column holding
the foreign keys for the A set and the column holding the primary keys for the B
set.
-
Browse the catalogs/schemas in your database connection to reach the table
holding the column you want to match.
In this example, the column to be analyzed is
customer_id that holds the foreign keys.
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.
-
Click the table name to display all its columns in the right-hand panel of the
Column Selection dialog box.
-
In the list to the right, select the check box of the column holding the foreign
keys and then click OK to proceed to the next
step.
You can drag the columns to be analyzed directly from the DQ
Repository tree view to the editor.
If you right-click any of the listed columns in the Analyzed
Columns view and select Show in DQ Repository
view, the selected column will be automatically located under the
corresponding connection in the tree view.
-
Click B Column Set and follow the same steps to
select the column holding the primary keys or drag it from the DQ Repository to the right column panel.
If you select the Compute only number of rows not in
B check box, you will look for any missing primary keys in the column in
the B set.
-
Click Data Filter in the analysis editor to
display the view where you can set a filter on each of the analyzed columns.
-
Press F6 to execute this key-matching analysis.
A confirmation message is displayed.
-
Click OK in the message if you want to continue
the operation.
The execution of this type of analysis may takes some time. Wait till the
Analysis Results view opens automatically showing
the analysis results.