< Previous | Next >

Analyzing the GOSALESDW schema in the physical data model

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:

  1. Right-click the GOSALESDW schema in the Data Project Explorer and select Analyze Model.
  2. 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.
< Previous | Next >

Feedback