Data Exploration - Report
You can use the Report tab to conduct a detailed review of the relationships between all of the databases, tables, and fields that are included in your data exploration. If the report for the data exploration has not been generated, you can click Generate the report to generate it. The data exploration report contains the following elements:
Field Match Pane - When the Field Match riser is selected, displays a hierarchical list of the databases, tables, and fields included in your data exploration. The information displayed in the center of the Report tab depends on the level of the list that you select, as follows:
- All Databases - Displays a list of the databases included in the data exploration. Contains a field for a match count for each database.
- Database - Displays a list of the tables included in a selected database. Contains a field for a match count for each database.
- Table - Displays a list of the fields included in a selected table. Contains fields for a match count, the length, and the type for each field.
- Field - Displays a list of the fields that match a selected field. Contains fields for the table, the database, the type, the method, and the locale for each field.
Note: You can use the Set Group level tool in the toolbar to determine whether the Field Match pane groups tables and fields by database, table, or both. The Resources Pane contains a toolbar that enables you to attach a note to an object in the pane, see a field in a collection, or add a Profiling Task.
Identification Analysis Pane - When the Identification Analysis riser is selected, displays hierarchical list of definitions for all identification analysis definitions, selected identification analysis definitions, and identity matches. The information displayed in the center of the Report tab depends on the level of the list that you select, as follows:
- All Identification Analysis Definitions - Displays a list of the identification analysis definitions included in the data exploration. Contains a field for a match count for each identification analysis definition.
- Identification Analysis Definitions - Displays a list of the field…s that match a selected identification analysis definition. Each row contains information about the location of the field, its presence in the database, and the method used to identify the match.
- Identity Matches - Displays a list of the fields that match a selected component of an identification analysis definition. Each row contains information about the location of the field, its presence in the database, and the method used to identify the match.
Table Match Pane - When the Table Match riser is selected, displays a hierarchical list of the databases, tables, and fields included in your data exploration. The information displayed in the center of the Report tab depends on the level of the list that you select, as follows:
- All Databases - Displays a list of the databases included in the data exploration. Contains a field for a match count for each database.
- Database - Displays a list of the tables included in a selected database. Contains a field for a match count for each table.
- Table - Displays a list of the tables that contain a match for a selected table. Contains fields for the database, a match count, and the match percentage for each table.
- Field - Displays a list of the tables that contain a match for a selected field. Contains fields for the match count and the match percentage for each table.
Note: The Resources Pane contains a toolbar that enables you to attach a note to an object in the pane or add a Profiling Task. The Report Pane contains a toolbar that you can use to open a table, add a note, add a Profiling Task, or find a field in the Resources Pane.
Note that a set of risers is also displayed on the right-hand side of a data exploration tab. These risers give you access to related information about each field, definition, or table match that you have selected. The following risers are available:
Data Sample - Displays sample data for a selected field.
Notes - Displays any notes associated with a selected object. You can add, delete, and sort notes.
Collections - Displays a tree that contains any collections associated with a selected object. You can add collections.
Profile Task - Displays a tree that contains any profile tasks associated with a selected object. You can add, delete, and locate tasks.