The Column Management pane is available from the Options dialog box. To open the Options dialog box, select Options from the Tools group. Expand the General node, and select Column Management.
Column Management user preferences enable you to choose which columns to display on the grids for transformations, column selection, joins, and sorts. You can also set the column display order. The settings apply to all column-related dialog boxes.
The Column Management pane has the following fields and options:
Lists the column-related dialog boxes that can be customized. Expanding a folder will display check boxes that can be used to add columns to each dialog box.
Restores the default values.
Controls the information that appears in trees and grids. The available options are Name, Title, Description, and Alias. If no Title, Description, or Alias exists, the display will default to the Name.
Note: It is recommended that you use Title when working with Business Views.
Enables you to fully qualify field names in the JOIN criteria of a cluster synonym. The available options are Always and For duplicate fields. The default value is For duplicate fields, which allows you to maintain compatibility with earlier releases.
Expand any of the available Customize column display options to see default settings. Not all columns are on every grid. The following columns can be added:
Assigns an alternative name for a column or the real column name for a DBMS synonym.
Indicates the application where the synonym resides.
Shows the parent segment.
Indicates the adapter connection name used.
Indicates the date the synonym was created.
Indicates when the synonym was last modified.
Is a description or comments about the column.
Is the expression for the column.
Indicates the suffix (data source type) of the synonym.
Indicates that a column is an index (I) or is read-only.
Is the type and length of a column data as stored.
Indicates the name of the function.
Indicates that the synonym includes foreign keys.
Indicates an index column.
Indicates the conditions for the join.
Indicates the parent of the join.
Indicates strategy for the join.
Indicates the keys in the synonym.
Is the column length.
Indicates whether or not the column can contain null data.
Indicates the number of segments in the synonym.
Indicates the order of the column in the segment.
Indicates a prefix for the column.
Indicates the primary key for the synonym.
Indicates whether the column is an attribute or a measure.
Indicates the actual name of the table or the physical file name.
Indicate a reference for the column to an index column.
Is the maximum number of digits to the right of the decimal.
Used for processing slowly changing dimensions.
Indicates the parent segment.
Indicates the size of the synonym.
Indicates the source of the synonym.
Indicates how SQL is converted.
Is the synonym that contains the column.
Supplies a title to replace the column name normally used in reports.
Is the type of object in an application directory.
The following columns are available from each column display option. The default columns are shown in bold.
Belongs to Segment, Format, Expression, Description, Nulls, Segment, Type, Length, Scale, Alias, Title, SCD Type, Field Type, Index, Order, Property, Reference.
Format, Description, SQL Conversion Notes.
Table, Format, Description, Nulls, Prefix, Segment, Type, Expression, Length, Scale, Alias, Title, SCD Type, Field Type, Index, Order, Property, Reference.
You can change the display order of the columns by moving them up or down using the arrows.