Performing the Preliminary Data Transfer

Use this process to test the transfer and determine what additional rules need to be created to move the data from the source table into the target table. During the preliminary transfer, the source table column properties such as length and data type are compared to the properties in the target table column. If the data cannot be moved from source to target due to incompatible properties, the system tries to create a rule for the column transfer, based on the available system rules. These rules show how the source data must be transformed in order to be accepted in the target database. You must update the values in the Import Table Column Rules Definition form for the newly applied rules, and then rerun the preliminary data transfer to apply the rule. Continue this until no errors are encountered.

In the preliminary data transfer, no data is moved to the target table.

To perform the preliminary data transfer:

In the Import Data Transfer form, select the starting and ending sequence numbers of the tables you want to transfer. The sequence numbers are defined on the Import Steps form.

Note: You can specify a range of tables. However, we strongly recommend that you transfer one sequence at a time.
Select Generate Data Assessment Report to generate a report for data validation. Send this report to the appropriate department for validation.
Specify the On Error setting:
- Stop: If multiple sequences are imported at one time and an error occurs, the utility stops the import at the sequence that encountered an error.
- Continue: If multiple sequences are imported at one time and an error occurs, the utility tries to import the later sequences.
In either case, the Final Data Transfer option is disabled until all of the specified sequences are imported successfully.
Select Preliminary Data Transfer.
Click Process.

The prompt Task Submitted is displayed, and you are prompted to open the report folder and view the Data Assessment Report.
Check the Log tab during processing for messages. Processing might take several minutes to complete.
After correcting all errors, rerun the Preliminary Data Transfer until all mapped columns have a status of Preliminary Success.
After the preliminary data transfer is completed successfully, you can run the final data transfer.