The Data Type Standards Editor lets you map physical data types to physical data types, which is useful when you want to derive a new physical model from an existing physical model, or change the target DBMS.
To map physical data types to physical data types
The Data Type Standards Editor opens.
Note: If you need to connect to a mart, click Connection on the Services menu and enter your connection information.
A new window opens within the Data Type Standards Editor at the New Mapping tab.
The table is populated with the default physical to physical data type mapping, and the New Mapping tab is renamed with the data type mapping you just created, for example, Sybase 12.5 to Oracle 10/11.
The data type standards model file is saved and remains open.
Note: If you try to save the file without making any changes to the default data type mapping, you are alerted that no changes are detected, and the *.dsm file will not be saved.
The Data Type Standards Editor closes.
Copyright © 2011 CA. All rights reserved. | Email CA Technologies about this topic |