 |
 |
Archives of the TeradataForum
Message Posted: Mon, 12 Apr 2004 @ 22:19:53 GMT
| Subj: | | Re: Why does table need to be empty for Fastload |
| |
| From: | | Christie, Jon |
It might help to know a little history. Fastload is one of the oldest Teradata utilities. It is optimized for the empty target table case, and
it's stable. Modifying it to also handle the case of a populated target table would be a project of some scope and would - at least for a while -
have a destabilizing effect.
Why do that when there's already another utility to handle the populated target table case? Just use Multiload in that case.
Or you could fastload your new data into an (empty) temporary table and then insert/select from the temporary table to the (populated) target
table.
Jon
| |
