O'Reilly logo

Tera-Tom on Teradata Utilities V12-V13 by Tera-Tom Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 3 — FastLoad

“Where there is no patrol car, there is no speed limit.”

- Al Capone

FastLoad is known for its lightning-like speed in loading vast amounts of data from flat files from a host into empty tables in Teradata. Part of this speed is achieved because it does not use the Transient Journal. But, regardless of the reasons that it is fast, know that FastLoad was developed to load millions of rows into empty Teradata tables.

FastLoad loads data into EMPTY Teradata tables in 64 K Blocks. The only command FastLoad understands is INSERT!

Rule #1: No Secondary Indexes are allowed on the Target Table. High performance will only allow FastLoad to utilize Primary Indexes.

Rule #2: No Referential Integrity is allowed. FastLoad cannot ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required