To learn TDM, I’m creating a logical model from an existing model published as a Javadoc-like set of HTML pages, to better see its structure in different Workspaces.
Many tables have strings which are in fact keys with a given structure, so I’d like to model those with a “logical” type of StringKey instead of as plain varchar(x) attributes.
But it looks like there are several ways to do this:
- As a Domain
- As a Type Dictionary (not with Oracle 11g?)
- As a User-defined Data Type
The doc is a little light on what these are individually (or I missed it), and doesn’t explain in which situation one would use a Domain vs. a UDT.
What are the pros and cons of each?
Influence on the Physical Model generation?
Thanks for any help on this. --DD