Roadmap for converting data with Optim on distributed platforms

Use this roadmap to guide you through the convert process with Optim™ on distributed platforms.

To convert data, do the following:

  1. Create a convert request
    Use the convert request editor to define parameters for processing the convert request. These parameters include the source extract or archive file, control file, and destination file. You must also include a table map. To convert data using the data privacy functions, define these functions in a column map specified in the table 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, convert data, or exclude columns from a process. You can include one or more column maps in a table map.

  2. Run the convert process

    Use the convert request editor to run the convert process. The convert process transforms the contents of an extract or archive file before you perform an insert or load.