Teradata Utilities Flashcards

What is the primary purpose of the BTEQ (Basic Teradata Query) utility?

Answer: Submits SQL and procedural commands to Teradata and formats output for reports

BTEQ is a general-purpose command-line utility for submitting SQL, DDL, and DCL statements to Teradata and formatting query results for scripts and reports.

Which Teradata load utility is best suited for initial bulk loading of an empty table?

Answer: FastLoad

FastLoad uses multiple parallel sessions to load data into an empty table at very high speed by bypassing the transient journal.

What is the key advantage of MultiLoad over FastLoad in Teradata?

Answer: MultiLoad supports DML operations (INSERT, UPDATE, DELETE, UPSERT) on non-empty tables

MultiLoad can perform multiple DML operations (INSERT, UPDATE, DELETE, UPSERT) on up to five tables simultaneously, making it suitable for maintaining large non-empty tables.

What does TPT (Teradata Parallel Transporter) provide that individual utilities like FastLoad and MultiLoad do not?

Answer: A unified, scriptable framework combining load, export, and transformation operators in one job

TPT is a unified framework that encapsulates the functionality of FastLoad, MultiLoad, FastExport, and other utilities into composable operators within a single portable job script.

In Teradata's FastLoad process, what must be true about the target table before loading begins?

Answer: The table must be empty and have no secondary indexes or join indexes

FastLoad requires the target table to be completely empty and have no secondary indexes or join indexes, which are dropped before the load and rebuilt afterward.

What is the purpose of the TDMS (Teradata Data Mover) utility?

Answer: Copies objects and data between Teradata systems with high performance

Teradata Data Mover copies database objects (tables, views, macros) and their data between Teradata systems, supporting migration and replication scenarios.