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:
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. |