The star schema model is a specially configured logical model for designing star schema data warehouses.
Star schema models have the following main settings:
- No connection
- Relations between attributes
- Predefined entity types
- Predefined entities
The following items are available from the workflow for models in this category:
REPLACE WITH THIS IMAGE: Resources/Images/StarSchemaModel.png
Items |
Description |
---|---|
Generate artificial keys |
Refer to Creating an Artificial Key for details. |
Show pivot table |
Refer to Creating a Pivot Table for details. |
Document model |
Refer to Documenting a Model for details. |
Compare models |
Refer to Comparing the Structure of Two Models for details. |
Generate DDL |
Refer to Generate DDL for details. |
Create load and stage |
Refer to Generating Load and Stage Wizard for details. |
Advanced copy |
Refer to Copying a Model Version - Quick and Advanced Copy for details. |
Merge into other model |
Refer to Merging Models for details. |