The existing data warehouse model can be used to document an existing data warehouse.
After discovering the structure of an existing data warehouse, you can assign table types to entities in order to distinguish between dimensions, facts, data stores and other types of star schema tables and views.
At the end of the design process, a word document describing the data warehouse can be generated.
Data warehouse models have the following main settings:
- A connection to an existing data warehouse
- Relations between attributes
- Basic predefined entity types
The following items are available from the workflow for models in this category:
Items | Description |
---|---|
Derive relations | Refer to Derive Foreign Key Joins Wizard for details. |
Assign table types | Refer to Assigning Entity Types for details. |
Document model | Refer to Documenting a Model for details. |
Compare models | Refer to Comparing the Structure of Two Models for details. |
Advanced copy | Refer to Copying a Model Version - Quick and Advanced Copy for details. |