|
Click in the Image (to Zoom) OR
on the "Check Mappings"
Button to open a screenshot OR
on any Column Name in the Destination (right) side to open a Step by Step tutor page
(hover your mouse on the Buttons to display the Task TIP)
|
|
|
Blobs
When the Table has Blob Data type Column(s) these will be stored in (internal) Temp Tables. Depending on thresholds defined in your settings this can be done either in Memory (faster) or in HD (slower)
In this example they are used in Memory Tables as displayed on screen (check docs for more detailed explanations)
Listbox Icons & Colors
To display a Legend Infos screen click on the relevant button
Data (Tab)
To display the First 50 records already read, click on this Tab
Table Structures (Tab)
To display the Table Structures (helpful to understand duplicates from the Unique Keys), click on this Tab
|
|
|
Step 1 : Link Columns
Use the Radios to select the type of linking method to use then click on the "Link Columns" Button OR use
Drag & Drop from Source Column to Destination
Clear link & mappings : select the Column in Destination side and
right-click (option to clear all functions - conditions etc...)
|
|
Step 2 (optional) : Chek your mappings
If you wish to see what your data will be AFTER applying the mapping options click on Button "Check Mappings" and you will have access to a new Tab where you will be able to scan on the first 50 records with all MAPPINGS applied (you can do it here to open a popup window with a screenshot)
|
|
Open Column Mapping Screen
If you wish to define a column Mapping you double-click on the column Name to work on in the Destination Right Panel (click there to start the Tutor)
|
|
Step 3 (optional) : Save as Profile
You can save all these settings (source and destination) in a Profile to use again at a later time (use Button "Save as Profile")
(this allows you for example to test different mappings combinations)
|
|
Step 4: Transfer Data
When you are satisfied all is defined as you need, launch the Data Transfer process (Button
"Transfer Data") - you will be able to repeat this as many times as you wish "playing" with Ranges and mapping options
|
|
Options you can define before Transferring
|
|
Number of Records and Record Ranges
You can define the Number of Records to Transfer or the Low and High Range to transfer
(this allows you for example to transfer only from record #125 to record #255)
|
|
Source SORTING order
You can define the Source SORTING Order : Drag & Drop from
Source Column to relevant entry field, add a leading - if you need a descending order on the added column (default is ascending and you do not need to add a leading +)
(this allows you for example to sort the source table in any special way you may require during Updates)
|