16.10 - Differences Between BTEQ and Teradata PT - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

BTEQ and Teradata PT can both load data into Teradata and can update tables, among other functions. Other similarities include:

  • Capacity – Both can send up to 64 KB per request and up to 1 MB per request with array support.
  • Capabilities – Both can support multiple sessions and can load, export, process DDL, and act as a command line interface.

The following table explains the major differences between BTEQ and Teradata PT:

BTEQ Teradata PT
Consumes less client CPU. Consumes more client CPU.
Loads or updates either all records or stops after x records that you specify with the REPEAT command. Can also load or update only selected rows.
Limited error handling. Performs error handling and creates error log tables.
No checkpoint restart. Checkpoint restart.
No SERIALIZE option. SERIALIZE option ensures the correct sequencing of transactions.
Does not process multiple DML statements in a single pass of the input data. Can perform conditional apply or multiple apply.

Recommendation: If your job has millions of rows, use Teradata PT. If not, especially for a load job that will be used again in the future, consider both. See which performs better and causes less system overhead. BTEQ can be a good choice for smaller amounts of data, exploratory work, and DDL.