Data Domain Discovery Export Files in Informatica Analyst
When you export data domain discovery results from the Analyst tool, you can specify the file name, file format, and code page value. You can export data domain discovery results to a Microsoft Excel file.
The Microsoft Excel file contains multiple worksheets that separate discovery results based on columns, data domains, and data domain groups. The Properties worksheet displays profile properties, such as name, description, type, location, date and time last changes were made to the profile, and a link to the profile.
Data Domain Discovery Results in Microsoft Excel
When you export the data domain discovery results to Microsoft Excel, the Analyst tool saves the column names, names of matching data domains, and percentage of conformance and null values. The Excel file also contains the data domain group names for each data domain and documented datatypes for the columns.
The following table describes each worksheet in the export file:
Tab | Description |
|---|
View by Columns | Data domain discovery results sorted by data source column. |
View by Data Domains | Data domain discovery results sorted by data domain. |
View by Data Domain Groups | Data domain discovery results sorted by data domain group. |
Properties | Basic profile properties, such as name, description, type, location, date and time last changes were made to the profile, and a link to the profile. |
Exporting Data Domain Discovery Results from Informatica Analyst
You can export the data domain discovery results to an .xlsx file so that you can view the data in a file and distribute it within the enterprise for further use.
1. Run a profile to perform data domain discovery.
2. Click the Data Domain Discovery tab.
3. Click Actions > Export Data.
The Export data to a file dialog box appears.
4. Enter the file name. Optionally, use the default file name.
5. Select the code page of the file.
6. Click OK.