Teradata Utilities Flashcards

In BTEQ, what does the .LOGON command do?

Answer: Establishes a session connection to a Teradata system

The .LOGON command in BTEQ connects to a specified Teradata system using the provided host, username, and password to begin a session.

What is the FastExport SESSIONS parameter used for?

Answer: Specifies the number of parallel sessions to use for the data export

The SESSIONS parameter in FastExport controls how many parallel sessions are opened, directly affecting throughput for large data extractions.

Which phase of a MultiLoad job is responsible for acquiring locks and reading the input data file?

Answer: Acquisition Phase

During the Acquisition Phase, MultiLoad reads input data, acquires table locks, builds hash tables, and loads rows into work tables on each AMP.

What does the BTEQ command .SET WIDTH do?

Answer: Sets the maximum line width for report output formatting

.SET WIDTH specifies the maximum character width of each output line in BTEQ, controlling how reports wrap or truncate when printed.

What is the role of the Teradata Archive/Recovery (ARC) utility?

Answer: Backs up and restores Teradata databases, tables, and journals

ARC (ARCMAIN) performs online and offline backup and recovery of Teradata databases, tables, and journals to tape or disk-based media.

In Teradata's TPT framework, what is an 'operator'?

Answer: A reusable component that performs a specific data movement function such as reading, writing, or transforming data

TPT operators are plug-in components — producers read data (e.g., ODBC operator), consumers write data (e.g., Load operator), and filters transform data between them.