- Extraction
- Loading
- Updating
These capabilities can be extended with customizations or third-party products.
Teradata PT uses but expands on the functionality of the traditional Teradata extract and load utilities: FastLoad, MultiLoad, FastExport, and TPump, also known as standalone utilities.
Teradata PT can load data into and export data from any accessible database object in Database Engine 20 or other data store using Teradata PT operators or access modules.
Load Operator
The Load operator uses the Teradata FastLoad protocol to load a large volume of data at high speed into an empty table in Database Engine 20.
The Load operator is typically used for the initial loading of Teradata tables. This operator inserts data from data streams into individual rows of a target table.
Update Operator
The Update operator emulates the Teradata MultiLoad utility to perform highly scalable and parallel inserts, updates, deletes, and upserts into new or pre-existing database tables in a single pass.
The Update operator can also be used to insert new rows into the database, but cannot perform select operations. The Update operator is not supported for column-partitioned tables.
Export Operator
The Export operator uses the Teradata FastExport protocol to extract large amounts of data at high speed from Database Engine 20 using block transfers over multiple sessions. The Export operator reads data from one or more tables in Database Engine 20.