Archives of the TeradataForum

Message Posted: Fri, 14 Dec 2007 @ 21:52:21 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

For a complete refresh, FLOAD is "faster", which is by definition, "better", if that is acceptable to you. FLOAD assumes an empty table, either drop/create table, or del from table beforehand.

MLOAD is for update in place, or to load a previously populated table.

Quincy Leslie
Sr. Systems Coordinator - EDW/BI

	<Prev	Next>		<<First	<Prev	Next>	Last>>