3.5.1 Steps to Create Lookup Table

Lookup table has to be created in the ERwin model.

The following are the steps:

1. Open the ERwin model in ERwin Data Modeler tool.
2. Create a new subject area.
3. Create a table and add columns to the table.
4. Lookup table needs to at-least have one primary key column.
5. Lookup table needs to at-least have one numeric non-key column.
6. Such numeric columns will be the return value of the lookup.
7. Specify logical names, comments and primary key for the table.
8. Specify logical names, domains and comments for the column.
9. Domains for the columns can be LEAF, BALANCE, RATE and so on.Save the model.