Getting ready

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.