In this scenario, you will use the same set of tables from the sample database that are used for Scenario 1, but the Extract Process in Scenario 2 is more complex. Scenario 2 also demonstrates Move's ability to transform, age, and update when migrating the set of data. Similar to Scenario 1, Scenario 2 demonstrates how to migrate a relational set of data in two steps.
The first step describes how to specify, extract, and store a relational set of data.
The second step describes how to transform data, insert the new data, and update existing data in the destination tables.
Scenario 2 directs you through the steps required to extract a set of data for specific items, including the details and the orders for the items. To obtain the desired set of data, you will specify the ITEMS table as the Start Table and select specific ITEMS rows using the Point and Shoot Editor. Since the extracted set of data must be referentially intact, this scenario will include the orders for these items (from the ORDERS table), the customers who placed the orders (from the CUSTOMERS table), and the DETAILS table rows for any order that contains the selected items.
Scenario 2 uses the same destination tables created in Scenario 1. The Insert Process in Scenario 2 also updates the destination data and uses a Column Map to modify data.