Teradata FastLoad is a command line utility that can be used to load large amount of data into an empty table on Teradata database. The performance will be greater than line by line or batch processing mechanism.
This takes Teradata utility slots, which might also cause other load jobs to fail. Specifying the FASTLOAD= data set option on a SAS library hides it from users. In a business intelligence environment, it might be difficult to determine whether this option is specified.
- Please visit Teradata Documentation for the latest technical publications, user guides, and reference manuals, including PDFs.
- UNIX and Windows Examples - FastLoad Teradata FastLoad Reference prodname FastLoad vrmrelease 15.10 category Programming Reference featnum B035-2411-035K.
- Teradata Bteq Reference Manual Teradata Bteq Reference Manual file: casio edifice 5123 manual 00 volvo s80 t6 repair manual 2012 mustang owners manual apple manual pages arctic cat xf 800 owners manual hitachi zx75us 3 zx85us 3 excavator service manual alfa romeo 147 workshop.
- Teradata Client Tools (Fastload) on the client machine to access the Teradata DB. Those are installed together with the DB. Those are installed together with the DB. If you want to run PDI and Terafast on a separate machine, you need to install the Client Tools separately there.
This article provides example of using FastLoad to load CSV file into Teradata database.
Example CSV file
Create a sample CSV file named test_fastload.csv with the following content:
Create FastLoad job script
Example CSV file
Create a sample CSV file named test_fastload.csv with the following content:
Create FastLoad job script
Create a FastLoad job script that performs the following actions:
- Logon to the database;
- Drop target table;
- Create target table;
- Load data into the target table;
Teradata Fastload Csv
To implement this, create a FastLoad script file named load-csv.fastload. The content looks like the following:
Teradata Fastload Download
To run FastLoad job, the two error tables should not exist and also the target table should be empty.
The above script recreate the target table each time thus the logon user needs to have CREATE TABLE permission on the target database. It also sets the input format as variable text file with delimiter as ','.
Run FastLoad script
Command fastload can be used to run the script file:
The output looks like the following:
What Is A Reference Manual
Verify the data
Run the following SQL statement to verify the result:
The result set looks like this:
Interactive mode
We can also run fastload using interactive mode. To do this, type fastload command in Command Prompt:
And then input each command with prefix '.'.
For example, use '.LOGON …' to logon to the database:
References
Teradata FastLoad Reference
