Book Image

Teradata Cookbook

By : Abhinav Khandelwal, Viswanath Kasi, Rajsekhar Bhamidipati
Book Image

Teradata Cookbook

By: Abhinav Khandelwal, Viswanath Kasi, Rajsekhar Bhamidipati

Overview of this book

Teradata is an enterprise software company that develops and sells its eponymous relational database management system (RDBMS), which is considered to be a leading data warehousing solutions and provides data management solutions for analytics. This book will help you get all the practical information you need for the creation and implementation of your data warehousing solution using Teradata. The book begins with recipes on quickly setting up a development environment so you can work with different types of data structuring and manipulation function. You will tackle all problems related to efficient querying, stored procedure searching, and navigation techniques. Additionally, you’ll master various administrative tasks such as user and security management, workload management, high availability, performance tuning, and monitoring. This book is designed to take you through the best practices of performing the real daily tasks of a Teradata DBA, and will help you tackle any problem you might encounter in the process.
Table of Contents (19 chapters)
Title Page
Dedication
Packt Upsell
Contributors
Preface
Index

Introduction


A data warehouse is comprised of many tables, and we rarely get an answer with one table alone. To get business answers, we need to join two or more tables. In upcoming recipes, we will see how to improve this joining and troubleshoot some of the issues that occur while joining tables.

We will answer the following questions in our recipes:

  • What join types are supported in Teradata
  • The difference between outer and inner joins
  • Resolving product joins
  • How to improve join performance

The following illustration gives a better understanding of the relationship:

There are two methods of writing joins; one is with Oracle syntax, and the other ANSI, which is the recommended one. The following is a query with Oracle syntax:

/*Query with Oracle Syntax*/
SELECT  A.QTR_YEAR, A.WEEK_YEAR ,  B.INVOICE_NME 
FROM  Table_A.CUR  A, Table_B.INVOICE_CNTY b ,  
WHERE  B.store_Id=A.CNTY_id 
and A.type_name='MOD'
GROUPBY 1,  2;
/*Query With ANSI Syntax*/
SELECT  A.QTR_YEAR, A.WEEK_YEAR ,  B.INVOICE_NME 
FROM...