Posts

Showing posts from June, 2020

Teradata Utilities

Image
Teradata Utilities Teradata offers utilities that support the management and maintenance of a data warehouse on a Teradata database. Some Teradata utilities include:  FastLoad   FastExport  TPump   MultiLoad FastLoad is a parallel-load utility that is designed to move large volumes of data from data sources on channel-attached and network-attached clients to empty tables in a Teradata database. FastLoad typically provides better performance than a standard application program that loads data to an empty database because data allocation, data conversion, data movement, and data loading run automatically and in parallel. Features:   Performs the initial table load.   Supports delimited or fixed-width flat file input.   Processes large data volumes. Constraints:   The target table must be empty before the load.   No read or write access is allowed on the target table while the load occurs.   ...