Use this roadmap to guide you through the convert process with Optim™ on distributed platforms.
To convert data, do the following:
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.
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.
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.