Fast Export in Teradata

    Teradata fast export:-

As the name suggest, fast export is a utility which transport data from Teradata tables and views to user define file format using multiple sessions.

Below is the sample fast export script:-

Above is the sample fast export script. It starts from creating log table in the Teradata database, login into Teradata database, specifying output file and the select query.

While specifying select query, you would always need to cast your output to get it in your desired format. Also you would need to mention mode and format of the output file.

Now, let’s try to execute the above script:-

To execute above script, you would need to type fexp in command prompt and the path of the above script file. 

After executing above script, Teradata will create file on D:\log\Log\0512\ location called FASTEXPORT.CSV

Read Also:-