Teradata Fastload

Teradata Fastload is a utility which loads records into an empty table using blocks of records and multiple amps. Fastload is composed of 2 phases, the first phase reads the unix records, and writes them to TOS buffers on the amps. The second phase reads the TOS buffers and writes them to a TOS database table.

Fastload Performance:

CHECKPOINTS:

Fastload provides the capability to issue a checkpoint in the 2nd phase of the fastload. This checkpoint is an increment of rows being loaded into the table. A checkpoint is issued after each increment of rows. If a fastload process gets aborted in the 2nd phase, then the fastload can be rescued from the last checkpoint completed.

TABLE UPDATE PROCESS:

The fastload table update process is typically composed of 3 steps:

            1) Fastload:

                        Reads the unix records and loads them into temporary database table.

            2) Delete:

                        Deletes the rows from the permanent table, where the primary indexes of the

                        temporary and permanent tables match.

            3) Insert

                        Inserts the rows from the temporary table into the permanent table. 

Tweet