Using the Column Map Editor
In the Column Map Editor you can create, modify, or delete Column Maps stored in the Optim™ Directory or defined within a Table Map or Compare Request.
When you create a new Column Map, the grid is automatically populated based on your selections in the New Column Map dialog. You edit the values in the first grid column to map columns. For more information, see Create a column map. The names of the tables, for which columns are mapped, are displayed in the Source and Destination areas of the Column Map Editor.
- Source or Source 1
- File name and fully qualified table name, or table name only.
- Destination or Source 2
- Fully qualified table name.
- Description
- Text to describe the purpose of the Column Map (up to 40 characters).
- Procedure ID
- The Procedure Identifier qualifies any Column Map Procedures that are specified by the base name only. If you specify a fully qualified Column Map Procedure name in the Column Map, the Procedure ID is ignored. When you create a new Column Map, the Procedure ID is initially blank. You cannot run a Column Map Procedure in a UNIX environment.
- Server Name
- The location of the Extract or Archive File containing the source table, if any.
Grid details
The Column Map grid shows the mapped pairs of columns:
- Source or Source 1 Column
- Columns with the same name and compatible data types are automatically
matched. If a match is not found for a Destination or Source 2 column,
the status is NOT USED or REQUIRED. You can modify values in this
grid column.
A source column value in bold type can be viewed and edited from the Source Column dialog only. To open the dialog, double-click the value or use the Expand Source Column command. For more information, see Expand Source Column.
- Data Type
- Data type for a named Source or Source 1 column.
- Destination or Source 2 Column
- Names of the columns in the table. You cannot modify Destination or Source 2 column names.
- Data Type
- Data type for each destination column.
- Status
- Information about each pair of mapped columns. The following are
the Status indicators:
- Equal
- Columns have the same data type, and length.
- Mapped
- Columns do not have the same data type or length, but are compatible.
- Not Used
- No value for Source or Source 1 column. If you do not enter a
value:
- An Insert or Load Process inserts the default value that is defined to the database for the Destination column.
- An Update Process does not update the value in the Destination column.
- A Compare Process does not compare the value in the Source 2 column.
- A Convert Process does not convert a value to the Destination column.
- Unknown
*Unknown Source Column*
Unknown status occurs when you apply the Column Map to a table that does not include the column.*Unknown Destination Column*- Exit
- An exit routine determines the value for the Destination column.
- Expression or Function
- Character Expression
- The Source character expression determines the value that is placed in the Destination column.
- Numeric Expression
- The Source numeric expression determines the value that is placed in the Destination column.
- Age Function
- The Source age expression determines the value that is placed in the destination column.
- Currency
- The Source currency expression determines the value that is placed in the destination column.
- Transformation
- A data privacy transformation library function.
- NULL
- NULL is placed in the Destination column.
- Special Register
- Timestamp
- The Timestamp determines the value for the Destination column.
- Workstation ID
- The Workstation ID determines the value for the Destination column.
- Literal
- String Literal
- The Source string literal determines the value for the Destination column.
- Numeric Constant
- The Source numeric constant determines the value that is placed in the Destination column.
- TRUE Bit Value
- Boolean TRUE is the value for the Destination column.
- FALSE Bit Value
- Boolean FALSE is the value for the Destination column.
- Not Inserted
- Destination column cannot accept data. Move/Archive validation rules only.
- Error
- Certain statuses alert you to errors in mapping columns. You must resolve the errors to save a Column Map.
Menu commands
In addition to the standard commands on the File, Edit, and Tools menus, you can select the following commands from the Tools menu:
- Show
- Open the Show Columns dialog and select options to list columns according to status. For more information, see List columns according to status.
- Delete Entry
- Remove column names from the list. This command is enabled when a Destination or Source 2 column does not exist or is no longer valid.
- Expand Source Column
- Open the Source Column dialog for entering long Source Column values and functions. This command is available when Move/Archive validation rules are selected.
- List Columns
- Open the List Columns dialog and select from a list of Source column names. This command is available when Move/Archive validation rules are selected.