Use CSV files to import table relationships suggestions to the ILM repository. You can import suggested table relationships for tables with an application version or an application module.
The table metadata for all of the tables in the CSV file must be 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.
Copy the CSV file to a location that is accessible to the machine that hosts Data Archive.
In the Enterprise Data Manager, click
File
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 Relationships from Informatica Data Explorer
.
The Metadata Import Wizard appears.
Select
Import Table Relationships from CSV
and click
Next
.
Enter the full path of the location of the CSV file, including the file name.
For example,
/home/archive/optional/csv_import_kf.csv
.
Click
Finish
.
The Enterprise Data Manager imports the suggestions to the profiling suggestion table in the ILM repository. Review the suggested table relationships to import the suggestions as constraints.