< Previous | Next >

Analyzing the SAMP schema in the physical data model

In the exercise, you will analyze the SAMP schema in the physical data model. You can use the model analysis feature in the workbench to check for compliance with various rules and rule categories, including naming standards and SQL syntax.

It is important to analyze data models for compliance as they are being developed, especially before you transform one type of data model to another.

You can analyze the following data objects for compliance:
  • A database or schema in a physical data model
  • A package in a logical data model
  • A database or schema in a database connection in the Data Source Explorer

To analyze the SAMP schema in the physical data model:

  1. Right-click the schema SAMP in the Data Project Explorer and select Analyze Model.
  2. In the window that opens, keep all check boxes in the Physical Data Models node in the Rule categories list, and click Finish.
  3. Click Finish. In this case, you should see no errors or warnings. If there were errors or warnings, you could navigate from problems in the Problems view to the corresponding object in a diagram or the Data Project Explorer.
< Previous | Next >

Feedback