Rules and Guidelines for Discovering Relationships from ERwin Data Models
Rules and Guidelines for Discovering Relationships from ERwin Data Models
Consider the following rules and guidelines when you discover relationships from ERwin data models:
Create an export file for each schema that you want to discover relationships for. If the constraints are defined across schemas, then create one export file for all the schemas.
When you export the data model, use the Informatica PowerCenter export destination type. Configure the DBDNAME export parameter with the schema name that owns the tables. If you do not configure the export parameter, the imported suggestions do not show schema names. If the suggestions do not include schema names, you must select the schema name for the parent and the child tables before you can create the constraints.
Optionally, after you export the data model to an XML file, you might want to validate that the XML file is complete. The export file might not be complete if the data model is very large. Use the PowerCenter Designer or Repository Manager to import the file into the repository. If you can import the file without errors, then the file is complete.