Column Profile Drilldown
Use the drill-down options in a column profile 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 drill-down 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 drill-down filter for the matching column value. After you drill down, you can edit, recall, reset, and save the drill-down filter.
You can select columns for drill-down even if you did not choose those columns for profiling. You can choose to read the current data in a data source for drill-down or read profile data staged in the profiling warehouse. After you perform a drill-down on a column value, you can export drill-down 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 drill-down 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, data type, or pattern.
1. Run a profile.
The profile results appear in the summary view.
2. In the summary view, click a column name.
The column results appear in detailed view.
3. In the detailed view, right-click on a value in the Values pane, and select Drilldown.
The Data Preview pane displays the drilldown 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. Select a column value on the Values tab.
2. Right-click and select Drilldown.
The drilldown results appear in the Data Preview pane.
3. To add a filter condition, right-click a column value in the Data Preview pane, and select Add to Filter.
The Drilldown Filter dialog box appears with the filter condition.
4. Add the required filter conditions, and click OK.
You cannot apply drill-down filters to inferred data types.
5. To save the filter, click Actions > Save Filter.
6. To clear the drilldown filters, click Actions > Refresh.
7. To export drilldown data to a Microsoft Excel spreadsheet, click Actions > Export Data.