How it works...

Fast job is divided into two phases:

  1. Phase 1 – Acquisition Phase: The parsing engine (PE) receives data from the input file and sends it directly to Access Module Processors, AMPs. One session is used for an SQL session to define AMP steps, and the others for the SQL session for the log table. Data is sent in 64K blocks of records to each AMP. AMPs hash each record to the correct receiving AMP. At the end of phase 1, AMPs have rows in non-hash sequences.
  2. Phase 1 – Application Phase: When the END LOADING statement is received, the application phase of the FastLoad script starts. In this phase, the parcel received in step 1 will be sorted and sent to its destinations. AMP sorts the records on row hash and writes them to disk. ...

Get Teradata Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial