DWHPro Insights

Teradata FastExport: Exporting Large Tables Efficiently

By Roland Wenzlofsky ·

Teradata FastExport: Exporting Large Tables Efficiently

Teradata FastExport is a powerful tool for rapidly moving large volumes of data between Teradata Vantage and client utilities. This tool uses multiple sessions to export data to a mainframe-attached or network-attached file quickly.

To execute Teradata FastExport, SQL statements in the FastExport script are executed. The tool has two export modes: RECORD and INDICATOR. By default, INDICATOR mode is used, which utilizes indicator bits to mark NULL values. However, the RECORD mode may be more appropriate if you’re working on mainframes.

One of the major benefits of Teradata FastExport is that it supports exporting data in various formats, such as FASTLOAD, BINARY, TEXT, and UNFORMAT. This flexibility ensures that the exported data can be easily integrated into other systems.

In summary, Teradata FastExport is a highly efficient tool for exporting large volumes of data between Teradata Vantage and client utilities. Its support for multiple export modes and formats ensures maximum compatibility and ease of use.

Teradata Query Performance Tuning: The DWHPro Guide book cover

Get the complete Teradata tuning book, free

Teradata Query Performance Tuning: The DWHPro Guide
By Roland Wenzlofsky & Artemios Vogiatzis

206 pages on statistics and demographics, access paths and indexes, query execution plans, and joins. Get the full PDF and practical Teradata updates from DWHPro.

Confirm your email to receive your download link. Privacy policy. Unsubscribe in any newsletter.

About the free book

The Fastload format is used when FastExport copies data from one Teradata system to another. To create plain files, the TEXT format is mainly used.

When to use The Fastexport for Vantage instead of BTEQ?

FastExport uses parallel utility sessions, but BTEQ record export does not necessarily issue one SQL request per row. Compare supported modes, buffering, row width, network and measured workload before claiming a throughput advantage.

When Teradata FastExport is invoked, it spools the result set of the SQL query. However, it may be necessary to redistribute rows to assemble the data blocks, which can negatively impact performance. To mitigate this, the NOSPOOL option is available, which can enhance performance. However, this option has limitations, as it only supports basic SQL statements that involve selecting from a single table and sorting the exported data is impossible.

In summary, Teradata FastExport is a powerful tool for optimizing parallelism when exporting large amounts of data, making it a more efficient option than BTEQ. However, when utilizing FastExport, it is important to consider the potential need for row redistribution and to be aware of the limitations of the NOSPOOL option.

Here is an example script:

.LOGTABLE dwhpro.customer_log;  
.LOGON localhost/tuning,***;  
   DATABASE dwhpro;  
   .BEGIN EXPORT SESSIONS 4;  
      .EXPORT OUTFILE customers.txt  
      MODE RECORD FORMAT TEXT;
      SELECT CAST(Lastname AS CHAR(10)), 
         CAST(FirstName AS CHAR(15))
      FROM
      Customer;
   .END EXPORT;
.LOGOFF;

TPT provides export/load operators and a common job framework. Standalone utilities are not all internally managed by TPT; choose a supported utility/operator for the actual environment.

FastExport MODE RECORD FORMAT TEXT executed and wrote two fixed-width fixture records. This validates that combination only, not every format/mode, NOSPOOL eligibility or large-volume throughput.

Building or improving a data pipeline?

Discuss ingestion, transformations, orchestration, quality checks and operational handover.

Explore data engineering services

Teradata Query Performance Tuning: The DWHPro Guide book cover

Get the complete Teradata tuning book, free

Teradata Query Performance Tuning: The DWHPro Guide
By Roland Wenzlofsky & Artemios Vogiatzis

206 pages on statistics and demographics, access paths and indexes, query execution plans, and joins. Get the full PDF and practical Teradata updates from DWHPro.

Confirm your email to receive your download link. Privacy policy. Unsubscribe in any newsletter.

About the free book

Follow DWHPro in Google to see our articles more often in Search.

Leave a Comment

Teradata Query Performance Tuning: The DWHPro Guide book cover

Get the complete Teradata tuning book, free

Teradata Query Performance Tuning: The DWHPro Guide
By Roland Wenzlofsky & Artemios Vogiatzis

206 pages on statistics and demographics, access paths and indexes, query execution plans, and joins. Get the full PDF and practical Teradata updates from DWHPro.

Confirm your email to receive your download link. Privacy policy. Unsubscribe in any newsletter.

About the free book

Protected by Security by CleanTalk and CleanTalk Anti-Spam