The Import Metadata job initiates the table relationship discovery process when you discover relationships from ERwin data models. When you submit the criteria for the discovery, the ILM engine immediately runs the Import Metadata job in the background.
The Import Metadata job uses the parameters you specify in the wizard to locate the exported XML file. The job uses the PowerCenter DTD file to interpret the results in the exported XML file. The job finds the profiling information for the tables within the application version or application module that you initiated the discovery from. The job imports all the suggested unique, foreign, and primary key relationships to a profiling suggestion table in the ILM repository. The job does not create the constraints in the ILM repository. You must review the suggestions and then choose from which suggestions you want to create constraints.
When you submit the job, a message provides the job ID. Use the job ID to monitor the job status and the job log. The job log summarizes the parameters that you used to initiate the discovery, such as the full path of the exported xml file, the application version or application module, and the related tables that you ran the discovery for.