In this lesson, you will analyze the GOSALESDW 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.
Best practice: You should analyze your data models
for compliance when 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 GOSALESDW schema in the physical data
model:
- Right-click the GOSALESDW schema in the Data
Project Explorer and select Analyze Model.
- Select the Physical Data Model rules. In the window that opens, select the Physical Data
Model rule check box, then deselect the Design
suggestions check box. Click Finish to analyze the schema.
There are no errors or warnings in the Problems view. If you see errors or warnings in the Problems view, you can double-click the error to navigate from the problems
in the view to the corresponding objects or diagrams in the Data Project Explorer.