fbpx

The Teradata Fastexport in Vantage

By DWH Pro Admin

September 1, 2020


What is the Teradata Fastexport?

Teradata FastExport uses multiple sessions to rapidly move significant data volumes between Teradata Vantage and client utilities.

The destination for the exported information could be any mainframe-attached or network-attached file.

When Teradata Vantage FastExport is executed, the SQL statements in the FastExport script are executed.

Teradata FastExport can export in different modes: RECORD or INDICATOR. By default, the INDICATOR mode is used. The distinction between both is that the INDICATOR mode will use indicator bits to mark NULL values. If we are working on mainframes, we can use the RECORD mode.

FastExport for Teradata Vantage can export data in below formats:

  • FASTLOAD
  • BINARY
  • TEXT
  • UNFORMAT

The Fastload format is especially interesting when FastExport is used to copy 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?

The most important reason for utilizing Teradata FastExport is that it exports using several sessions, optimizing parallelism. Additionally, BTEQ exports data row by row, but FastExport does it in whole data blocks; from a performance point of view, this is a huge disadvantage if we export a vast amount of data.

After Teradata FastExport is invoked, it spools the result set of the SQL query. Redistribution of rows might be needed to assemble the data blocks, which might decrease performance. Therefore, an option can be used, which is called NOSPOOL; unfortunately, it limits the usage to basic SQL statements (selecting from only one table) and does not allow us to sort the exported data.

Here is an example scripts:

.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;

Using fast export on a Teradata Vantage system is no longer recommended as all utilities have been replaced by TPT (Teradata Parallel Transporter). TPT provides a common scripting language and offers many more options that are not available when using FastExport directly.

__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"62516":{"name":"Main Accent","parent":-1}},"gradients":[]},"palettes":[{"name":"Default Palette","value":{"colors":{"62516":{"val":"var(--tcb-skin-color-0)"}},"gradients":[]},"original":{"colors":{"62516":{"val":"rgb(19, 114, 211)","hsl":{"h":210,"s":0.83,"l":0.45}}},"gradients":[]}}]}__CONFIG_colors_palette__
__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"b4fbe":{"name":"Main Accent","parent":-1}},"gradients":[]},"palettes":[{"name":"Default Palette","value":{"colors":{"b4fbe":{"val":"rgb(241, 99, 52)"}},"gradients":[]},"original":{"colors":{"b4fbe":{"val":"rgb(19, 114, 211)","hsl":{"h":210,"s":0.83,"l":0.45}}},"gradients":[]}}]}__CONFIG_colors_palette__
Previous Article
__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"b4fbe":{"name":"Main Accent","parent":-1}},"gradients":[]},"palettes":[{"name":"Default Palette","value":{"colors":{"b4fbe":{"val":"rgb(241, 99, 52)"}},"gradients":[]},"original":{"colors":{"b4fbe":{"val":"rgb(19, 114, 211)","hsl":{"h":210,"s":0.83,"l":0.45}}},"gradients":[]}}]}__CONFIG_colors_palette__
Next Article
Buy the Book Teradata Query Performance Tuning

DWH Pro Admin

Roland Wenzlofsky is an experienced freelance Teradata Consultant & Performance Trainer. Born in Austria's capital Vienna, he is building and tuning some of the largest Teradata Data Warehouses in the European financial and telecommunication sectors for more than 20 years. He has played all the roles of developer, designer, business analyst, and project manager. Therefore, he knows like no other the problems and obstacles that make many data warehouse projects fail and all the tricks and tips that will help you succeed.

  • […] The Teradata Parallel Transporter (TPT) is a Teradata Tools and Utilities (TTU) product. Teradata TPT offers under one roof an SQL-like scripting language that simplifies the syntax of old Teradata Utilities for handling external data (e.g., FastLoad, MultiLoad, TPump, BTEQ, and FastExport). […]

  • {"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

    You might also like

    >