Archives of the TeradataForum
Message Posted: Tue, 12 Feb 2002 @ 15:56:25 GMT
Our tables are created using SET, NO FALLBACK, NO BEFORE JOURNAL, NO AFTER JOURNAL.
The load process use multiload for load data into a base table, app. 300.000 every day. The process verify the data, complete it and then load this data into the final table using
INSERT INTO bd1.table1
The two principal tables used the above process. The another nine tables using the follow process
INSERT INTO bd3.table3
I have a few experience in teradata only seven month, and i don't know how are the performance considerations.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|