Versions Compared

Old Version 1

changes.mady.by.user Wara Hermosa

Saved on

compared with

New Version 2

changes.mady.by.user eric revollo

Saved on

Key

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

...

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 and the underscore character.
Refer to the Column Properties for a more detailed description of the various fields.

...

SQL Server makes use of an identity attribute on the artificial key column.
The next section covers the Generating the Dimension Update Procedure.