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:
- Right-click the schema SAMP in the Data Project Explorer and select Analyze
Model.
- In the window that opens, keep all check boxes in the Physical
Data Models node in the Rule categories list, and click Finish.
- 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.