You can use a simplified way to create a table analysis with a predefined
business rule. All what you need to do is to start from the table name under the
relevant DB Connection folder.
Before you begin
-
At least one SQL business rule is created in the
Profiling
perspective of Talend Studio.
- At least one database connection is set in the
Profiling
perspective of Talend Studio.
Procedure
-
In the DQ Repository tree view, expand
Metadata > DB Connections, and then
browse to the table you want to analyze.
-
Right-click the table name and select Table
analysis from the list.
The New Table Analysis wizard is
displayed.
-
Enter the metadata for the new analysis in the corresponding fields and
then click Next to proceed to the next
step.
-
Expand Rules > SQL and then select the
check box(es) of the predefined SQL business rule(s) you want to use on the
corresponding table(s).
-
Click OK to proceed to the next
step.
The table name along with the selected business rule are listed in the
Analyzed Tables view.
-
Save the analysis and press F6 to
execute it.
An information pop-up opens to confirm that the operation is in progress and
the analysis editor switches to the Analysis Results
view.