Running Profile
After validating the profile, you can run the profile. Click 
, to run the profile. The Statistics tab displays the profile results in the drilldown charts view and summary rule. However, if you are on another tab in the profile and if you click validate, then the Statistics tab opens by default to view the results.
, to run the profile. The Statistics tab displays the profile results in the drilldown charts view and summary rule. However, if you are on another tab in the profile and if you click validate, then the Statistics tab opens by default to view the results.1. In the Profile Run Statistics window, the Results Summary pane displays the following information for each rule:
• Field: name of the field profiled
• Rule: the type of rule used in the profile
• Description: the profile statistics, for example, the percentage of passed and failed data
2. On the Results Summary pane, click on the required field name to view the pass or fail data in the graph representation on the right pane. Also, you can click on the ***The Counts- Total*** field to view the total pass and fail data in the pie chart representation and **Rule - BarCharts** field to view all the pass and fail rule in the bar chart representation.
Note: You can click on parts of the graph to view the data in the Drill Down Data view. You can also set pass and fail data settings in profile properties to create text files that you can browse.
Viewing Pass, Fail, and Drill Down Output
To view pass, fail, or drill down data output:
1. Run the profile and rule results and a graph of the selected rule is displayed on the Statistics tab.
2. In the Project Navigator view, expand the project folder and double-click the following files to view the output data in the editor.
• Fail.txt - FAIL_TARGET output displays data for the records that did not meet the specified criteria within the applied rule
• Pass.txt - PASS_TARGET output displays output data for the records that met the specified criteria in the applied rule.
• Stats.json - STATS_TARGET output displays a graphical representation of the rule from the profile run that is automatically generated. However, it is not suggested to integrate this file into automated business processes.
• DrillDown.txt - DRILLDOWN_TARGET displays output data for the records that does not meet the criteria specified in the applied rule. This file is primarily used by Data Profiler to enable drill down reporting. However, you can use this file to browse in the editor to illustrate the relationship between the FAIL_TARGET records and the corresponding rule.
Rule and Their Resulting Outputs
Some rule display their results in pie charts and some results are displayed in bar charts. However, Distinct Values or Duplicate Values do not create graphic output. There are two charts that represent overall results:
• Counts Total displays pass and fail counts in a pie chart graph.
• Rule-BarChart displays all pass and fail rule data in a single bar chart with each rule pass and fail represented in a separate bar.
• Each rule pass and fail data is shown in an individual pie chart.
The following table provides information about the outputs for each rule and rule function:
Rule Name | Graphic | Additional Output |
|---|---|---|
Compare to Constant, Compare to Field | Pie Chart | None |
Is Blank, Is Not Blank, Is Null, Is Not Null | Pie Chart | None |
Maximum, Minimum, Mode, Sum | None | Statistical values |
Standard Deviation | None | Statistical values |
Equal Range Binning, Most Frequent Values | Bar Chart | None |
Distinct Values | None | Text file of distinct values |
Duplicate Values | None | Text file of distinct values |
Last modified date: 02/01/2024