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.