User Guide > Designing and Executing Data Profile > Configuring the Source and Target > Understanding and Specifying Data Profile Targets
Was this helpful?
Understanding and Specifying Data Profile Targets
There are four pre-configured targets or output files:
Target Name
Description
Supported Connectors
Changeable?
PASS_TARGET
(Pass.txt)
Contains records that passed all rules ("clean" data).
Used for downstream processing of valid data.
• (default) Unicode (Delimited)
• ASCII (Delimited)
• ASCII (Fixed)
• Unicode (Fixed)
• JDBC
The schema used will match the one shown in the Rules tab.
Yes (Connector, File Name, Location)
FAIL_TARGET (Fail.txt)
Contains records that failed at least one rule ("dirty" data).
Used for review or manual cleanup of problematic data.
• (default) Unicode (Delimited)
• ASCII (Delimited)
• ASCII (Fixed)
• Unicode (Fixed)
• JDBC
The schema used will match the one shown in the Rules tab.
Yes (Connector, File Name, Location)
DRILLDOWN_TARGET (DrillDown.txt)
Used internally to enable interactive drill-down functionality, 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.
Unicode (Delimited)
File Name and Location can be changed, but the Connector type is fixed.
STATS_TARGET (Stats.json)
Contains execution results (total Data Quality Index score (see Viewing Statistics)
Dimension scores (see Data Quality Dimensions)
Pass/fail counts and percentages per rule).
Displaying results in the Statistics tab > Results Summary grid.
JSON
Only Location can be changed.
Note:  You can disable writing data to the PASS_TARGET and FAIL_TARGET in the Configuration tab > Execution Options by setting the Write Pass Content in PASS_TARGET? option and the Write Fail Content in FAIL_TARGET? option to No.
Additional information about DRILLDOWN_TARGET:
• 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).
 
On the Target tab, the target and the target schema are pre-configured. However, you can change the file location and the Connector or Connection information for the PASS_TARGET file and FAIL_TARGET file. For more information, see Setting Up Target Data.
Note:  Only Replace output mode is available for the target Output mode. You can save the results in a database by changing the target connectors for the Pass and Fail targets to use JDBC to write directly to any database that supports JDBC.
Last modified date: 01/08/2026