Archives of the TeradataForum
Message Posted: Tue, 09 Apr 2002 @ 18:12:09 GMT
| Subj: || || Delete Trigger on Multiloaded Table |
| From: || || Yonina Schuchman |
I posed this question to the GSC and have not received a definitive response. The manuals say that you should not have triggers on
tables that are Multiloaded. I have a test table with a delete trigger (V2R4.1.1). We multiloaded the table(upserts only) without
disabling the delete trigger. The multiload was successful. I would like to put this delete trigger on my production table and not have to
bother disabling and reenabling the trigger whenever the table is loaded. We will never delete from this table using Multiload.
Is there any reason I shouldn't do this?
Yonina Schuchman, DBA
Charming Shoppes, Inc.