Use this roadmap to guide you through the insert process with Optim™ on distributed platforms.
To insert 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, modify data, or exclude columns from a process. You can include one or more column maps in a table map.
Use the Insert Request Editor to run the insert process. The insert process inserts data from an extract files to the original or to a different database.