Archives of the TeradataForum
Message Posted: Sun, 08 Apr 2007 @ 20:17:26 GMT
| Subj: | | Re: Merging large volumes of data into large history tables |
| |
| From: | | Michael Larkins |
You might look into the use of AXSMOD as a way to eliminate the need for FastExport in transferring your data from your source table to your
target table. Of course the data must still be taken from Teradata, sent to the host computer running Mload and then back to the target table for
the merge operation.
As for Teradata "de-emphasizing" these older utilities, anyone paying attention would realize the emphasis is now being placed on TPT which was
called Warehouse Builder originally. It has many options for either row at time or block oriented operations as well as the ability to scale
input and output operations. It is just too bad that the scripting language is so long and hard to understand - unlike the ease of scripting the
original utilites.
As for the NO LOG option on a volatile table mentioned by an Anom user, that is ANSI convention and has nothing to do with Teradata
specifically. Besides, it would not help you anyway because you need to get the rows into a real table and there is no way to turn off the
Transient Journal on one of them. The only way for SQL to not use the Transient Journal is when the operation is going against an empty
table.
Regards,
Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor
| 
