You can generate profiles if you have the Data Discovery option and if you have native connectivity from the Informatica server to the source database server. A connection to the source database and Data Quality is required. If you retired the source database, you can connect to the Data Vault.

When you discover table relationships from Data Quality, you generate a profile for primary key and foreign key profiling. The profile analyzes the percentage of matched values across table columns to determine primary key and foreign key relationship probability and uniqueness.

Data Quality uses the source metadata in the ILM repository to drive the profile analysis on the source database. You initiate the discovery from the application version or from the application module levels of the source metadata in the ILM repository. You choose the tables to profile and configure parameters that determine how Data Quality generates and runs the profile. You can generate profiles for one schema at a time. When you discover relationships at the application version level, the discovery occurs for the default schema. When you discover from the application module level, then the discovery occurs for that schema only.

The profile results are stored in the profiling database. After you generate the profile, you can view the profile results within the Enterprise Data Manager. The job ID has the information required to connect to Data Quality and to obtain the profile results. When you view the results, the Enterprise Data Manager connects to the profiling database and imports the results from the profiling database to the ILM repository. Then, you can import the suggestions as constraints.

If you retired the application, you might need to define constraints for imported source metadata after you retired and decommissioned the source database. You want to use the constraints to create entities for data discovery. You can connect to and generate profiles for the Data Vault instead of the source database.

When you discover table relationships from Data Quality, you initiate the discovery from the source metadata that you originally imported from the source database. You do not have to import metadata from the Data Vault.