TeraTeam UK Teradata DBA Definition
Fastload:
FastLoad is a command-driven utility to load large data into an empty table on a Teradata Relational Database Management System (RDBMS).
You can load data from:
- Disk or tape files on a channel-attached client system
- Input files on a network-attached workstation
- User defined input module (INMOD) routines to select, validate, and preprocess input data
- Any other device providing properly formatted source data
FastLoad uses multiple database sessions to load data.
Constraints on the use of fastload are
- the target table must be empty
- no access (read or write) is allowed on the target table while loading
- only a single table can be loaded in one job
An alternative to fastload is MultiLoad which does not have the above restrictions, but also has a significantly slower load performance.
