The Insert Request Editor dialog allows
you to select parameters for processing the Insert Request, including
the following:
- The
Extract File that contains
the data to insert.
- The Control File that tracks
the process.
- The Table Map that matches tables
in the Extract
File to tables at the destination.
- Specifications
to delete rows in target tables prior
to the Insert.
You can choose to run the
Insert Request immediately
or schedule the request for later processing.
Process
Options
- Insert
- If the primary key value is unique to the destination
table, the new row is added to the destination table. If the primary
key value is not unique to the destination table (the row already
exists), the row is discarded. Move uses a Control File to keep track
of discarded rows so that you can review them and possibly reprocess
them later.
- Update Only
- If the primary key of a row in the source data matches
the primary key of a row in the destination table, the row is updated.
If the primary key of a row in the source data does not match the
primary key of a row in the destination table, the row is reported
as failed.
- Update/Insert
- If the primary
key value is unique to the destination table, the new row is added
to the destination table. If the primary key value is not unique to
the destination table (the row already exists), the row in the Extract
File replaces or updates the existing row.
- Mixed
- Move also allows a mix of
insertion methods where
some tables are inserted and others are updated.
Object Definitions
If
destination tables do not exist, Move can generate the SQL to create
the tables from the object definitions contained in the Extract File─either
as part of the Insert or as a separate step. In addition to tables,
other object definitions can be created.