User Guide > Designing and Executing Data Profile > Understanding Data Profile Targets
Was this helpful?
Understanding Data Profile Targets
There are four pre-configured targets or output files:
• Pass.txt (PASS_TARGET): This output file contains the “clean” data. That is all rows that pass every data profiling rule. It is optional and not required while designing your profile. If you do not wish to write to this output file, go to the Configuration tab, Execution Options section, and set the Write Pass Content in PASS_TARGET? option to No.
By default, it generates a Unicode (Delimited) text file, but you can change the format to ASCII (Fixed), ASCII (Delimited), JDBC, or Unicode (Fixed). The schema used will match the one shown in the Rules tab.
You may choose to generate this file to send clean data downstream for further processing.
• Fail.txt (FAIL_TARGET): This output contains the “dirty” data. That is all rows that fail at least one data profiling rule. It is optional and not needed during profile design. If you do not wish to write to this output file, go to the Configuration tab, Execution Options section, and set the Write Fail Content in FAIL_TARGET? option to No.
By default, it generates a Unicode (Delimited) file, but the format can be changed to ASCII (Fixed), ASCII (Delimited), JDBC, or Unicode (Fixed). The schema matches what is shown in the Rules tab.
You may choose to generate this file to pass the failed data downstream for review or manual cleanup.
• DrillDown.txt (DRILLDOWN_TARGET): This output file enables drill-down functionality within the Data Profiler, allowing users to explore which rows passed or failed specific rules by interacting with visual elements like pie and bar charts in the Data Browser.
– Format: Unicode (Delimited)
– File name and location can be changed, but the connector type is fixed.
– Based on the schema from the Rules tab, extended with one column per rule. Each rule column contains an "X" for rows that fail that specific rule.
– Behavior in Charts:
• Clicking a failed chart segment displays all rows with an "X" in the corresponding rule column.
• Clicking a passed segment shows rows without an "X" in that rule’s column.
– Data Formatting:
• Uses the same Boolean and date/time formats as the source data (e.g., Y/N or True/False).
• Exception: For DMS connectors (e.g., Netsuite, ServiceNow, Oracle CRM), Booleans are always shown as True/False, and dates follow ISO 8601 format (e.g., 2022-05-16T08:24:16+00:00).
This file provides the underlying data for interactive pass/fail drill-down analysis directly from visual summaries.
• Stats.json (STATS_TARGET): This JSON file is used to display profile execution results in the Statistics tab, and contains overall statistics including:
– Total Data Quality Index score (see Viewing Statistics)
– Dimension scores (see Data Quality Dimensions)
– Pass/fail counts and percentages per rule
It provides the data shown in the Statistics tab under the Results Summary grid.
 
Last modified date: 09/22/2025