 |
 |
Archives of the TeradataForum
Message Posted: Wed, 24 Jun 2009 @ 13:25:48 GMT
| Subj: | | Re: ET in Teradata DELETE MLOAD |
| |
| From: | | Victor Sokovin |
| | While defining DELETE MLOAD, we define WT and ET. | |
| | In which situation does a row/rows go to an ET table while performing MLOAD DELETE ? | |
Good question. I don't think I ever had to inspect the ET table after the MLOAD DELETE so don't have ready-to-use examples but I can imagine it
may possibly be populated by rows which were not deleted due to, say, potential violation of hard-coded referential integrity with other tables.
Not that I had to use the latter in Teradata either so my suggestion is purely hypothetical and requires validation by experiments.
Victor
| |
