Introduction
The Teradata Database provides several utilities to load, delete, or update large volumes of data. Utilities are the most efficient way to load data into a database. Utilities are designed to utilize the parallel architecture of Teradata while inserting, deleting, or updating data. This also means that if they are not designed properly, these utilities can have performance impacts on the system.
The following are the utilities in Teradata:
- Fastload: Bulk load utility
- Mload: Bulk load utility
- Fastexport: Bulk export utility
- BTEQ: Use of transient journal
- TPUMP: Use of transient journal
Let's see how these utilities compare with each other:
Utility Name | Type | Advantages | Disadvantages |
Fastload | Single table bulk load |
|
|