The Import Metadata job gets a list of all imported source metadata in the ILM repository for the application version or application module that you initiated the discovery from and the tables that you selected to profile. The job connects to Data Quality from the metadata import connection properties that are configured on the

Profiling and Discovery

tab of the

System Profile

page. The job uses a list of the source metadata and the parameters that you specify to connect to the source database and to generate the profile. The profiling job profiles for the primary key and determines the best possible key for the table. Then, the job uses the results of the primary key profile and runs the foreign key profile. You configure whether the primary keys can include composite keys on the

Profiling and Discovery

tab of the

System Profile

page.

The job imports the suggested primary key and the foreign 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 suggestions that you want to create constraints from.

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 includes the parameters of the discovery, such as the discovery method you used and the parameters that you entered for the discovery tool. The job log shows the application version or application module and the related tables that you ran the discovery for, and the other parameters you used for the discovery.