Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

...