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, Optim populates the grid automatically on the
basis of your selections in the New Column Map dialog.
You edit the values in the first grid column to map columns. See Create a Column Map for
details. The names of the tables, for which columns are mapped, are
displayed at the top 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 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. Note that 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. Status indicators
are:
- 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
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 Destination
Column*
Unknown status occurs when you apply the Column Map to
a table that does not include the column.
- Exit
- An exit routine determines the value for the Destination column.
- Expression or Function
- Character Expression
- The Source character expression determines the value placed in
the Destination column.
- Numeric Expression
- The Source numeric expression determines the value placed in the
Destination column.
- Age Function
- The Source age expression determines the value placed in the destination
column.
- Currency
- The Source currency expression determines the value 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 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 errors in order 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. See List Columns According to Status for details.
- 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.