Importing Profile Results from Informatica Data Quality
Importing Profile Results from Informatica Data Quality
To import profile results that were generated in Informatica Developer, export the profile results to an XML file. Then, initiate the discovery from the application version or application module of the source metadata.
Verify that the metadata import properties are configured on the
Profiling and Discovery
tab of the
System Profile
page. The Enterprise Data Manager uses the properties to connect to Data Quality to obtain the profile results.
Verify that the metadata for all of the tables in the profile results is imported in the ILM repository. The ILM engine can use suggested table relationships to create constraints only for tables that exist in the ILM repository.
If you use the Data Vault as the source, you initiate the discovery from the metadata that you imported from the source database. You do not have to import metadata from the Data Vault.
Copy the exported profile results XML file to a location that is accessible to the machine that hosts Data Archive.
In the Enterprise Data Manager, click
View
Constraints
to open the constraints tab.
In the navigation pane, select the application version or application module that you want to discover relationships for.
Click
File
Discover Keys and Relationships
.
The Metadata Import Wizard appears.
Select
Import Profile Results from Informatica Data Quality
and click
Next
.
Enter the full path of the location of the exported XML file, including the file name.
For example,
/home/archive/ilm/optional/pk_export.xml
.
Choose the profile type that the profile results include.
Click
Finish
.
The Enterprise Data Manager connects to Informatica Data Quality to obtain the profile results and imports the suggestions to the profiling suggestion table in the ILM repository. Review the suggested table relationships to import the suggestions as constraints.