You can run column profile and data domain discovery as part of enterprise discovery in the Analyst tool.
1. In the Discovery Home panel, select New > Profile.
The New Profile wizard appears.
2. Select Enterprise Discovery . Click Next.
The Specify General Properties tab appears.
3. In the Specify General Properties tab, enter a name for the profile and an optional description. In the Location field, select the project or folder where you want to create the profile. Click Next.
The Select Data Objects tab appears.
4. In the Select Data Objects tab, click Choose.
The Choose Data objects dialog box appears.
5. In the Choose Data objects dialog box, choose one or more data objects to add o the enterprise discovery profile. Click Save.
The data objects appear in the Data Objects pane.
6. Click Next to open the Select Resources tab.
7. In the Select Resources tab, click Choose to open the Select Resources tab.
You can import data from multiple relational data sources.
8. In the Select Resources tab, select the connections, schemas, tables, and views that you want to include in the enterprise discovery profile. Click Save.
The left pane in the dialog box lists all the internal and external connections, schemas, tables, and views under the Informatica domain.
The resources appear in the Resource pane.
9. Click Next.
The Specify Discovery Settings tab appears.
10. In the Specify Discovery Settings tab, you can configure the column profile options and data domain discovery options. Click Save and Finish to save the enterprise discovery profile or click Save and Run to run the profile.
You can perform the following tasks in the Specify Discovery Settings tab.
- - Enable data domain discovery. Click Choose to select data domains that you want to discover from the Choose Data Domains dialog box. The selected data domains appear in the Data Domains for Data Domain Discovery pane.
- - Run data domain on data, columns, or on both data and columns.
- - You can select all the rows in the data source, or choose a maximum number of rows to run domain discovery on.
- - Select a minimum conformance percentage for domain discovery.
- - Enable column profile settings and select all rows or first few rows in the data source for the column profile. You can exclude data type inference for columns with approved data types in the column profile.
You can view the enterprise discovery results under the Summary and Profiles tabs.