Editing target data in a table map
Use the Table Map Editor to edit target data stores, schemas,
and tables for source tables in a table map.
Managing actions
Use supplemental SQL statements (actions) to be executed
at selected phases of an archive, delete, insert, extract, or restore
process. For example, you might use an action to audit deleted rows
by executing an appropriate SQL statement before the start of the
delete process, or after the deletion of each row. You can also create
an SQL statement to call a stored procedure. You can define actions
for all phases, including insert or restore phases, in the access
definition, which is copied to the archive or extract file during
processing. Any insert actions in the access definition become the
default actions when data is inserted but can be overridden in the
table map that is used in the insert, load, or restore process. For
load processing, however, actions for many phases are disregarded.