Plan the Logical Layer

Use the topics in this section to determine the logical layer's content.

Topics:

• Guidelines for Identifying the Logical Layer's Content

• Identify the Logical Fact Tables

• Identify the Logical Dimension Tables

• Identify Dimensions

• Identify Lookup Tables

• Logical Layer Design Tips

• Model Outer Joins