Copy Trigger | Data Mover Portlet | Teradata Data Mover - Copying a Trigger - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.10
Published
June 2021
Language
English (United States)
Last Update
2021-06-16
dita:mapPath
fcu1619423186706.ditamap
dita:ditavalPath
mpm1591127278842.ditaval
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem
You can copy triggers to a target Teradata system. If you enable the trigger, you can specify whether to place the trigger on the target table before or after the table is loaded.
  1. In the Objects tab, click "" to expand the tree.
  2. Click "" to expand a database or user object where the trigger is located.
  3. To filter so only triggers display, do the following:
    1. Click "" and clear all check marks except for Trigger.
    2. Move the cursor away from the object-types filter to refresh the tree with triggers in the sub-branch.
  4. Click "" to display the Trigger Settings dialog box.
  5. [Optional] To activate the trigger and designate when to place it on the target table, select Enabled and do one of the following from the Action Time list:
    • Select BEFORE to place the trigger on the target table before the table is loaded. A trigger action occurs for each row that is copied from the source.
    • Select AFTER from the Action Time list to place the trigger on the target table after the table is loaded. No trigger action occurs for rows that are copied from the source.
  6. Select OK.