Teradata Utilities Flashcards

What is the Teradata TDLOAD utility primarily used for?

Answer: A command-line interface for TPT that simplifies load job creation without scripting

TDLOAD is a command-line wrapper around TPT that automatically creates and executes a TPT load job without requiring the user to write a full TPT script.

In Teradata, what is the purpose of the Viewpoint portal?

Answer: A web-based monitoring and management interface for Teradata systems

Teradata Viewpoint provides a web-based dashboard for monitoring system health, workload management, query performance, and user activity across Teradata nodes.

Which Teradata utility is used to validate referential integrity constraints defined outside the database?

Answer: Teradata Validation Utility (TVT)

The Teradata Validation Utility (TVT) checks data consistency and referential integrity, particularly useful for validating data migrated from other systems.

What are FastLoad error tables used for?

Answer: Store rows that failed to load due to constraint violations or conversion errors for later review

FastLoad creates two error tables (ET and UV tables) that capture rows rejected due to data type errors, duplicate UPI violations, or other constraint failures.

What is the function of the .SET TITLEDASHES command in BTEQ?

Answer: Controls whether dashes are printed under column headings in BTEQ output

.SET TITLEDASHES ON/OFF controls whether BTEQ prints a line of dashes beneath each column heading in formatted output reports.

In Teradata Parallel Transporter (TPT), what is the difference between a Load operator and an Update operator?

Answer: Load operator inserts into empty tables bypassing logging; Update operator supports INSERT/UPDATE/DELETE on populated tables

The TPT Load operator performs FastLoad-equivalent bulk inserts into empty tables with minimal logging, while the Update operator performs MultiLoad-equivalent DML on existing populated tables.