O'Reilly logo

Data Modeling Made Simple with CA ERwin Data Modeler r8 by Steve Hoberman, Donna Burbank

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The Query Tool enables you to write SQL queries against an external database. This is particularly helpful to be able to compare your model design against ‘real world’ data values to validate against a sample data set. For example, in Figure 16.30, the physical data model design lists the customer_number column of the CUSTOMER table as an integer. Using the Query Tool to display the data values that exist in the actual database, we see that the customer_number field in the physical database contains alphanumeric values, indicating a mismatch between the model and the physical implementation. Note that there are other ways to do this type of comparison in CA ERwin Data Modeler, notably the Complete Compare feature, which would ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required