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

Compare with Current View Page History

Version 1 Next »

The Derive Table Type Wizard is used to detect and set table types on a large number of tables in one simple wizard process. The wizard can be started manually from within a diagram.
Operating the wizard:

  1. Start the wizard using the diagram toolbar button:

REPLACE WITH THIS IMAGE: Images/Wizards/Table Type Wizard.png
or the context menu on the model version tree node:
REPLACE WITH THIS IMAGE: Images/Wizards/Table Type Wizard_1.png

  1. Click REPLACE WITH THIS IMAGE: Images/Common_Icons/addqueryicon.png to specify the tables to be included or excluded using SQL wild cards and click Next.

REPLACE WITH THIS IMAGE: Images/Wizards/Table Type Wizard_2.png

  1. The tables matching the criteria in the last step are displayed. Move any specific tables not to be included to the Exclude tables list and click on Next.

REPLACE WITH THIS IMAGE: Images/Wizards/Table Type Wizard_3.png

  1. Define the table type name patterns for each table type defined in the model and click Display.

REPLACE WITH THIS IMAGE: Images/Wizards/Table Type Wizard_4.png

Note

You should check the name matching pattern against each table type before proceeding. In the example above, you should check Fact and Dimension.
Additional criteria for each table type can be specified using the edit buttons.
  1. All table types to be assigned are now listed. Turn off any table type assignments you do not want to include and click Finish.

REPLACE WITH THIS IMAGE: Images/Wizards/Table Type Wizard_5.png
The model version diagram is now redrawn to include the table type assignments.

  • No labels