Using the Extract file created in the Scenario 2 Extract Process, you will specify an Insert Process that also inserts new rows and updates existing rows in the destination database. You will use the same destination tables used in Scenario 1, but the Scenario 2 Table Map will include a Column Map that transforms the inserted data. Scenario 2 uses the remaining Insert Request settings from Scenario 1.
This scenario builds on the Insert Request created in Scenario 1. To begin, open that Insert Request.
Move populates the Insert Request Editor with the specifications saved in Scenario 1.
Before you modify the Insert Request for Scenario 2, click to display the Save an Insert Request dialog and create a copy of the original Insert Request.
Type a new name to create a copy of the Insert Request for Scenario 2. The original Insert Request will remain unchanged and modifications for Scenario 2 will apply only to the new copy.

Type a new Description for the Insert request, and specify the following parameters on the General tab:
to
specify the last Extract File. If the Scenario 2 Extract File was
not the last Extract File created, use the Browse button
to locate the file.