Scenario 1 – A Set of Customers

Scenario 1 guides you through the steps required to create a test database of data from four sample tables distributed with Optim™. The data in the test database will include a sampling of customers. To create the test database, you must extract a subset of related data from the source database and insert the data into a target database.

Scenario 1 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 insert the relational set of data into newly-created destination tables.

In this scenario, you will create a subset of data by extracting every tenth CUSTOMERS row in the sample database. The subset of data will also include all orders from the selected customers (from the ORDERS table) and the details for those orders (from the DETAILS table). The data also includes all rows from the ITEMS table, which is designated as a Reference Table. The extracted data will be inserted into new database tables created during the Insert Process.

Note: If you are not authorized to create new tables, you may be unable to complete the Insert Process in this scenario. Check with the site management for the destination tables to use.