Modifying Object column properties

On the DWD Designer tab, click the Designers tab.

Right-click on an object and select Modify columns.

View the list of columns from the edit columns page.

From the list, double-click on the column name of the object which you want to view or modify the property.

You can also activate column for Measure audit control by selecting the Audit check box.

Note: Repeat steps 3 and 4 to activate other columns for audit.

You can also select these options:

You can select any from Mandatory Options.

Mandatory Options	Description
Mandatory	Null values are not allowed.
Nullable	Null values are allowed.

You can select any from Column Key Options.

Column Key Options	Description
Natural Key	The natural key column functions as a business key. Natural key columns are often the company, item number and customer number columns.
Identifier	The identifier functions as a surrogate key for the natural key.
Static Non Key	The static non key column option functions as the non key in previous versions of DWD.
Updated Non Key	The column key option is used when changing columns are managed. Columns tagged as Updated Non Key are updated when there are no changes in columns tagged as Changing Column when Slowly Changing columns are managed.
Changing Column	A changing column cannot function as a key. An update of this column updates a data mart table. If a changing column is located in an object such as a dimension table and the slowly changing dimensions option is used, a change to this column generates a new dimension instance. A new instance means that a new dimension identification is created for that column.

You can select any from Calculation Properties.

Calculation Properties	Description
Normal	Where a column is normally mapped 1—1 to another column.
Calculated	Where there are underlying calculations that define the column. The column is calculated from one or more columns or consists of a constant value.
Modified Date	Only set for columns that belong to a data source table. This is used to define what should be used as a filter when extracting business data incrementally. This is also used when performing incremental updates from the data source systems.
Join Connector	The column is not compiled and has never been uncompiled physically on the Microsoft SQL Server. This function is only used to link three or more tables together if the destination’s object columns are based on only two non-related objects.