Primary Components
Load Operator, using the FastLoad protocol, is a parallel load utility designed to move large volumes of data collected from data sources on channel- and network-attached clients into empty tables in the Teradata Database.
Update Operator optimizes batch operations that rapidly acquire, process and apply data to tables in a Teradata Database by using the MultiLoad protocol. For data maintenance, MultiLoad updates, inserts and upserts large volumes of data into empty or populated tables and/or deletes data from the tables. MultiLoad works at the data block level, providing an alternative to insert/select operations that touch a significant portion of the target table. A single MultiLoad job can maintain up to five Teradata tables by extracting large volumes of data, locking the destination tables and then loading data using block level updates.
Export Operator exports large data sets from Teradata tables or views and imports the data to a client's system for processing or generating large reports or for loading data into a smaller database. It uses the FastExport protocol. Like all Teradata load utilities, FastExport can export data to channel- or network-attached client systems. FastExport also provides session control and data handling specifications for the data transfer operations.
Stream uses the SQL-based TPump protocol, not block-based, for continuous loading that is designed to move data from data sources into Teradata tables without locking the affected table. TPump loads near- real-time data into the data warehouse, allowing users to maintain fresh, accurate data for up-to-the-minute decision making. TPump can be used to insert, update, upsert and delete data in the Teradata Database, particularly for environments where batch windows are shrinking and data warehouse maintenance overlaps normal working hours. Because the TPump protocol uses row hash locks, users can run queries even while they are updating the Teradata system.
Script Converters
TPT Wizards
Next Steps
Teradata Express Edition
Experience Teradata Express Edition — a free developer version of Teradata 12.0. It provides an unlimited opportunity to work with Teradata on Windows workstations and laptops for development, testing and learning.
Download Now
How can we help?
Contact us for insight and answers to your questions.
Contact Teradata
