BTEQ and Teradata PT | Teradata Vantage - 17.00 - 17.05 - Differences Between BTEQ and Teradata PT - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval

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.