To process the Insert Request, click Insert Request Editor.
from theThe Insert Request Progress dialog is displayed while the Insert Request is processed. The Insert Process populates the tables with the data from the Extract File.
If the status of any table in the Table Map is Unknown, meaning it does not exist, the Create Utility is opened. The Create Utility uses the object definitions in the Extract File to create those objects in the database.
When the Create Utility is opened, the Create dialog lists all objects in the Extract File that do not exist at the destination. Objects that do not exist at the destination are selected for the Create Process by default, unless a conflict exists.
In this scenario, the object types PK (for Primary Key) and FK (for Foreign Key) are in conflict. The Object Names of the Primary Keys and Foreign Keys in the Extract File conflict with names that already exist in the database.
For this scenario, resolve the conflicts by changing the Object Name for the objects in Conflict status. For example, insert T_ before each name, as shown below.
To create the objects, click from the Create dialog, or right-click and select the command from the shortcut menu.
The Review SQL dialog is displayed by default to enable you to examine the SQL produced to create the objects. The SQL can be edited, if necessary.
For this scenario, click Proceed to create the objects.
After the objects are created, the Browse SQL dialog is displayed, enabling you to browse the SQL statements and the results of the Create Utility. Click Continue to return to the Create dialog. The objects successfully created are displayed with the status of Created.
After the new objects are created at the destination, click from the Create dialog.
When the Insert Process has completed, the Insert Process Report is displayed. The report provides statistics and general information about the Insert Process.
You can optionally save or print the Insert Process Report. Click to save the report or to print it. To return to the Insert Request Editor, click .