Page History

...

• The first choice is a Normal dimension where a dimensional record is updated and changed whenever any of the nonbusiness key information changes.
• The second choice is a Slowly Changing dimension where new dimension records are created when certain identified columns change.

  Note
  For custom database targets, you can set the initial default values for the DSS columns that are used in the procedure generation for slowly changing dimensions. Refer to DSS Columns for Custom Targets for details.

  
  

• The third choice is a Previous values dimension, which enables the storing of the last values of selected fields in secondary columns.
• The fourth choice is a Date Ranged dimension, which supports source systems that provide start and end dates.

...

The following window appears after the Properties screen and asks if you want to create the dimension table in the database and execute the update procedure.

If you are satisfied with the columns that will be used and do not wish to add additional columns you can click the Create and Load button.
In this case, it would be normal practice to select the (Build Procedure...) option from the 'Update Procedure' drop-down box in the previous Properties window.
If no procedure has been selected then select the Create button as no update will happen in any event.
If Create or Create and Load is selected and a new procedure creation is chosen, proceed directly to the Generating the Dimension Update Procedure section.
If you have additional columns to add or columns to delete, click Close and proceed as follows below.

...

The columns defined for the dimension are displayed in the middle pane. 
It is possible to delete any unwanted columns by highlighting a column name or a group of names and choosing the Delete key.
The name of a column can also be changed by selecting the column and using the right-click menu to edit its properties. Any new name must conform to the database naming standards. Good practice is to use alphanumerics alphanumeric and the underscore character.
Refer to the Column Properties for a more detailed description of the various fields.

...