Teradata has many tools for writing the queries; you can use SQLA or a BTEQ for executing queries. There are also many third-party applications that connect to Teradata database using a data connector such as ODBC, JDBC, or .NET. Data loading utilities such as FastLoad, Multiload, or TPT can also be invoked using BTEQ or third-party apps. Here, we will use SQLA, the simplest of tools, to write a query, and show you how to use BTEQ.
Getting ready
Get Teradata Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
