Roadmap for creating a test database with Optim on distributed platforms

Use this roadmap to guide you through the process of creating and populating a test database with Optim™ on distributed platforms.

To create a test database, do the following:

  1. Create a database
    Use the Create Utility to create a database based on the metadata in an extract file. You must also include a table map, which can include a column map.
    • Create a table map

      Use a table map to specify correlating source and destination tables of compatible data. You can map tables that have different names, modify table names, exclude tables from a process, or include column maps for greater control over the data.

    • Create a column map

      Use a column map to define the specifications for mapping columns of compatible data between source and destination tables. You can map unlike-named columns, modify data, or exclude columns from a process. You can include one or more column maps in a table map.

  2. Populate the database using an insert or load process.
    • Insert archived data

      Use an Insert Process to insert data from an Archive File or Extract File into a destination database.

    • Load archived data

      Use the Load Process to transform the contents of an Archive or Extract File into a format that is appropriate for a particular DBMS loader and then, if desired, start the corresponding database load utility.