Teradata Utility -- FastExport

Hi All,

Today here we will discuss about FastExport  utility in Teradata.

• To export large volume of data from Teradata database to client.
• Takes advantage of multiple sessions.
• Fastexport sorts data rows before sending them through sessions.
• Can be used with INMOD/OUTMOD feature for external data sources and destinations.
• Restartable feature supported.

Example:

a).

.LOGTABLE sample_log;
.LOGON tdpid/username,password;
.BEGIN EXPORT SESSIONS 4;
.EXPORT OUTFILE out.dat;
SELECT * FROM employees
WHERE loc_name  = ‘MGRD’
 ORDER BY 1;
.END EXPORT;
.LOGOFF;
b).

.LOGTABLE sample_log;
.LOGON tdpid/username,password;
.BEGIN EXPORT SESSIONS 4;
.EXPORT OUTMOD out.dll;
SELECT * FROM employees
WHERE loc_name  = ‘MGRD’
ORDER BY 1;
.END EXPORT;
.LOGOFF;