Teradata FastExport
Teradata FastExport extracts large quantities of data in parallel from Vantage to a client. The utility is the functional complement of the FastLoad and MultiLoad utilities.
- Export tables to client files.
- Export data to an Output Modification (OUTMOD) routine.
You can write an OUTMOD routine to select, validate, and preprocess exported data.
- Perform block transfers with multisession parallelism.
Teradata FastLoad
Teradata FastLoad loads data into unpopulated tables only. Both the client and server environments support Teradata FastLoad.
- Load data into an empty table.
FastLoad loads data into one table per job. To load data into more than one table, submit multiple FastLoad jobs.
- Perform block transfers with multisession parallelism.
Teradata MultiLoad
Teradata MultiLoad supports bulk inserts, updates, and deletes for unpopulated or populated database tables. Both client and server environments support Teradata MultiLoad.
- Run against multiple tables.
- Perform block transfers with multisession parallelism.
- Load data from multiple input source files.
- Pack multiple SQL statements and associated data into a request.
- Perform data upserts.
Teradata Parallel Data Pump
Teradata Parallel Data Pump (TPump) uses standard SQL (not block transfers) to maintain data in tables.
TPump has a resource governing method whereby you can control the use of system resources by specifying how many inserts and updates occur minute-by-minute. This method enables background maintenance for insert, delete, and update operations at any time Vantage is in use.
- Unlimited number of instances running concurrently.
- Conventional row hash locking, which provides some concurrent read and write access to the target tables.
- Same restart, portability, and scalability as Teradata MultiLoad.
- Data upsert capability.