The Column Mapping operation allows you to map specific
columns to transfer between the source and destination
tables.
When configuring a Column Mapping record you must also configure an
associated Table Mapping.
SLIK provides two ways to create and maintain Table
and Column Mappings. Probably the easiest way to add a new mapping is to use the
Table/Column Map Wizard that walks through each aspect of a mapping. However,
once defined, you can use the main Table/Column Mapping Properties form to
change any mapping details.
Follow the steps below to perform column and/or table
mapping using the Data Transfer Wizard.
1.
Select Tools
®
Map Wizard to open the Data Transfer Wizard.
2.
Using the radio buttons provided, select whether the how the wizard
retrieves data sources and database column information:
Dynamic
to use the local machines data sources, or
Static
to use the data sources already defined in the SLIK
Control Database
and
click on the Next
> button.
3.
Select your Source
and Destination
datasources and click on the Next
> button.
To import a new datasource click on the ODBC
Data Sources… button and follow the Create New Data Source
wizard prompts.
4.
Select the Source
Table(s)
to be mapped to the Destination
Table and click on the Next
> button. It
is possible to select multiple source tables using the standard Windows Shift
and Control selection methods.
Note: SLIK does not allow you to map a table upon itself.
5.
If the source and destination datasources are structurally the same, i.e.
number of columns and data types, then select the Table
Map option and click on the Next
> button and jump to Step 10;
but
if the source and destination datasources are structurally different click on
the Column Map
option and click on the Next
> button.
6.
If any source and destination columns match SLIK will automatically map
them and the results would be displayed in the following window.
For those columns that have not been automatically matched activate the DstColumn
drop-down selection list by passing your mouse over the field until the
drop-down menu indicator appears, and select the required column value.
Column Mapping is used to define, or assign, the source and destination
columns.
The following mapping options are available to you:
a.
Enabled
– deselect a column by removing the corresponding check mark from the Enabled
column to indicate that the column is not to be mapped.
b.
Operator
– select a Hash Total operator to instruct SLIK to run a Hash Total operation
on completion of a transfer.
c.
Conversion ID –
select a Conversion ID value, i.e. data format, data translation, etc, if data
in the associated column is to be converted as part of the transfer process.
For example, this may be used to remove leading zeros from sequence
numbers, or to replace a customer number with a customer name.
Note that
mapping an integer column to a character column will store the integer value in
a destination char column. If a
conversion causes data truncation a warning message will be logged.
Optionally,
you may specify a hash total operator when defining a mapping.
Refer to the Hash Totals for further information.
Once completed click on the Next >
button.
7.
An optional text field is available to specify a SQL WHERE condition to
be used when selecting data from the source table.
If required, enter a WHERE clause (without the WHERE keyword) and click
on the Next
> button.
8.
The following screen summarises your Mapping chooses.
If changes are required, use the <
Back button to return to a previous screen.
To continue click on the Next
> button to complete the Mapping process.
9.
This displays the following screen that allows you to add another mapping
or to close out of the Mapping Wizard click on the Finish button.
The source WHERE Conditions can be
defined when using the Mapping Wizard. Once
a Mapping record has been created it is possible to return to the record (refer
to Working
with Existing Mapping Records) and create a Destination WHERE Condition. The Destination
Where condition is only needed if using the Hash Total feature in a column
mapping.
q
Open the Job Properties record and click on the
Map
button to open the Table Map Properties
grid.
q
Click on the directory tree cascade buttons (
) to show and hide the Column Mapping details associated with each Table Mapping
record.
q
Each record can be amended by entering a new
value into a field or selecting an alternative value from a drop-down menu.