Column Profile Drilldown
Drilldown options for a column profile enable you to drill down to specific rows in the data source based on a column value. You can choose to read the current data in a data source for drilldown or read profile data staged in the profile warehouse. When you drill down to a specific row on staged profile data, the Analyst tool creates a drilldown filter for the matching column value. After you drill down, you can edit, recall, reset, and save the drilldown filter.
You can select columns for drilldown even if you did not choose those columns for profiling. You can choose to read the current data in a data source for drilldown or read profile data staged in the profiling warehouse. After you perform a drilldown on a column value, you can export drilldown data for the selected values or patterns to a CSV file at a location you choose. Though Informatica Analyst displays the first 200 values for drilldown data, the tool exports all values to the CSV file.
Drilling Down on Row Data
After you run a profile, you can drill down to specific rows that match the column value or pattern.
1. Run a profile.
The profile appears in a tab.
2. In the Summary view, select a column name to view the profile results for the column.
3. Select a column value on the Values tab or select a column pattern on the Patterns tab.
4. Click Actions > Drilldown to view the rows of data.
The Drilldown panel displays the rows that contain the values or patterns. The column value or pattern appears at the top of the panel.
Note: You can choose to drill down on live data or staged data.
Applying Filters to Drilldown Data
You can filter the drilldown data iteratively so that you can analyze data irregularities on the subsets of profile results.
1. Drill down to row data in the profile results.
2. Select a column value on the Values tab.
3. Right-click and select Drilldown Filter > Edit to open the DrillDown Filter dialog box.
4. Add filter conditions, and click Run.
You cannot apply drilldown filters to inferred datatypes.
5. To manage current drilldown filters, you can save, recall, or reset filters.
- - To save a filter, select Drilldown Filter > Save.
- - To go back to the last saved drilldown filter results, select Drilldown Filter > Recall.
- - To reset the drilldown filter results, select Drilldown Filter > Reset.