You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

The Creating a Star Schema wizard enables you to create a star schema from source data.
To generate a star schema...

  1. Select an model version and select REPLACE WITH THIS IMAGE: Images/Common_Icons/data_warehouse.png Create star schema from the Workflow pane.

The Create star schema-Category configuration dialog is displayed.
REPLACE WITH THIS IMAGE: Images/Wizards/starschema1.png

  1. If needed complete the following...
    • Click on an entity type, click REPLACE WITH THIS IMAGE: Images/Common_Icons/renamequeryicon.png and modify the Name Prefix and Name suffix for the selected entity type.
    • Click on an attribute, click REPLACE WITH THIS IMAGE: Images/Common_Icons/renamequeryicon.png and modify the name for the selected attribute.
  2. Click Next.

The Create star schema - Model definition dialog is displayed.
REPLACE WITH THIS IMAGE: Images/Wizards/starschema2.png

  1. Enter a Name, Version for the model and click Create.

The Create star schema - Initial core concept design dialog is displayed.
REPLACE WITH THIS IMAGE: Images/Wizards/starschema3.png

  1. Select the entities to create the initial core concept design and click Finish.

The diagram is displayed.
REPLACE WITH THIS IMAGE: Images/Wizards/starschema4.png

  • No labels