Open Studio for Data Quality
In some cases, when you analyze database tables that have some duplicate records and a join clause, using an SQL business rule, the join results show that there are more rows in the joint than in the analyzed table.
You can generate a ready-to-use analysis to analyze these duplicate records. The results of this analysis help you to better understand why there are more records in the join results than in the table.
Before you begin
A table analysis with an SQL business rule, that has a join condition, is defined and executed in the Profiling perspective of Talend Studio. The join results must show that there are duplicates in the table.
For more information, see Creating a table analysis with an SQL business rule with a join condition.
Procedure
-
Right-click the join results in the second table and select
Analyze duplicates.
The Column Selection dialog box opens with the analyzed tables selected by default.
-
Modify the selection in the dialog box if needed and then click
OK.
Two column analyses are generated and listed under the Analyses folder in the DQ Repository tree view and are open in the analysis editor.
-
Click Analysis Results
at the bottom of the analysis editor to access the detail result view.
