Teradata FastExport is a command-driven utility used to transfer large amounts of data from tables and views of the Teradata Database to a client-based application.
It can generate data in the report format. Data can be extracted from one or more tables using Join.
FastExport exports the data in 64K blocks, and it is useful for extracting a large volume of data. Also, it can be exported from any table or view where the SELECT privilege has been granted. The destination for the exported data can be:
The following terms are commonly used in the Teradata FastExport script.
Consider the following Employee table.
Following is an example of a FastExport script. It exports data from the employee table and writes into a file empdata.txt.
Executing a FastExport Script
Once the script is written and named as emp.fx, we can use the following command to execute the script.
Next TopicTeradata BTEQ