Archives of the TeradataForum
Message Posted: Thu, 15 Mar 2012 @ 19:47:45 GMT
I think you are actually referring to the work table that Multiload uses for each target table (in Teradata the term "sub-tables" has a specific meaning which I don't believe is what you are referring to).
Fastload doesn't use a work table because it can only INSERT rows into an empty table, therefore there is no requirement for holding a copy of the input data (which is what goes into the Multiload work table) before applying changes to the target table.
Hope that helps.
Ward Analytics Ltd - Information in motion (www.ward-analytics.com)
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|