You can derive a generic physical model in which you specify DBMS-independent design decisions. You can then use the generic physical model to derive multiple physical models for specific DBMS environments.
When you derive a generic physical model, the same data types are assigned to columns as when you select ODBC as the target DBMS. When you use ODBC to connect to a database, the database is queried to determine which data types are supported and the supported data types display in the editors. By using ODBC to connect to your database, you can replace any generic data types with the data types supported by your database.
| Copyright © 2011 CA. All rights reserved. | Email CA Technologies about this topic |