Frequently Asked Questions › Models

Models

Question: What kinds of models can I validate with CA ERwin DMV?

Answer: Models created with CA ERwin DM (.erwin files), models from a script file with SQL/DDL statements, and database schemas from the DBMS Catalog or Dictionary.

Question: Does CA ERwin DMV process CA ERwin DM subject areas?

Answer: Yes. When you create a new project from an .erwin file, CA ERwin DMV will detect the subject areas and at this time you may select to process one subject area or none. Each subject area will create a sub model, associated to the main model.

Question: Can I drop a table from CA ERwin DMV analysis, without dropping the table from the CA ERwin DM model?

Answer: Yes. You can do this in several ways. One way is to go to User definitions, Table Processing. Another way is to right-click on the table on the Table tree and select Drop Table. A third way is to right-click on the tree on the entity-relationship (ER) diagram and select Drop Table.

Question: Can I add knowledge about my specific model to CA ERwin DMV?

Answer: Yes. There are several things you can do. You can define synonyms, define homonyms, and qualify columns, tables and relationships. Synonyms allow the user to define that two or more columns have different names but have the same meaning and therefore should be treated as the same. Homonyms are the opposite of Synonyms. Homonyms are when two or more columns have the same name, but they have different meanings and therefore should be treated differently.

Question: Are there any limits to the number of tables in the model?

Answer: No. There are no limits other than the ones imposed by your machine (for example, memory and speed). Models have been processed with well over 2000 tables. In this case, it is suggested that the model be processed initially with the FKs Only option. Later you may want to run the model again using the ALL relationships instead of the FKs Only option. This procedure will save you time.