The View Column Definition window is used for the automated re-mapping of certain column names. It provides an easy method for changing the column names for a large number of columns when creating a View.
The various actions undertaken as a result of entries in this window can all be done or reversed manually by changing the individual column properties.
The various fields are described below:
Fields | Description |
|---|---|
Remove Column Prefix | If the columns in the source table are prefixed then that prefix can be removed by entering it in this field. An example may be a date dimension which has each column prefixed with date_ (e.g. date_month, date_year, etc.). If this field is left blank then no removal action is taken. |
Add Column Prefix | If required a prefix can be added to each column name. This is particularly useful when defining a date dimension view where you would like each column to be prefixed by the date type. |
Remove Business Display Prefix | As per the column names, it may be required to remove a prefix from the business display fields. If so enter the prefix to remove in this column. |
Add Business Display Prefix | The business display fields are used in the creation of the glossary. It is therefore quite useful to prefix these display fields with an identifier for the view being created. It is assumed that these business display names will be carried forward to the end user layer. Enter a value in this field to prefix the business display name fields for each column. It is normal to include a space at the end of this field. |
Old Column Name | Up to five individual column names can be re-mapped. Enter the column name as it appears in the source table in one of the Old Column Name fields to re-map that column name. The business display name is also changed to match. |
New Column Name | Place a new column name alongside any existing column name you wish to re-map. In the example dialog above a column named calendar_date is being renamed to order_date in the view. |