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 may want to validate that the XML file is complete. The export file may 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 any errors, then the file is complete.