8.4. Using Triggers

Triggers can sometimes be used to good advantage during a load. If you're loading data into a work table, you can define an INSERT trigger that processes each row as it is loaded. In fact, triggers can be used to preprocess rows that go into any table. This saves you the trouble of invoking a separate program to do that work.

INSERT triggers are disabled during direct path loads. If you want to use INSERT triggers to manipulate data that you are loading, you need to perform a conventional path load.