Teradata cookbook : over 85 recipes to implement efficient data warehousing solutions / Abhinav Khandelwal, Rajsekhar Bhamidipati.

Format:

Book

Author/Creator:

Khandelwal, Abhinav, author.

Bhamidipati, Rajsekhar, author.

Language:

English

Subjects (All):

Data warehousing.

Physical Description:

1 online resource (448 pages) : illustrations

Edition:

1st ed.

Place of Publication:

Birmingham, England ; Mumbai, [India] : Packt, 2018.

Biography/History:

Khandelwal Abhinav: Abhinav Khandelwal has 11 years of industry experience in BI, analytics, and data warehousing. He gained a BE from GIT Sitapura, Jaipur. He is pursuing his MBA at Welingkar, Mumbai and is currently based in Melbourne. He acts as a senior consultant on BI DWH projects. He has also been in the news for his award-winning projects. For more information, you can refer to his blogs called as anonymously rave and three of kind. Contact him on Twitter at @abhi_khandu. Bhamidipati Rajsekhar: Rajsekhar Bhamidipati has 13 years' industry experience in Teradata and DWH and gained his BTech from BPUT Rourkela. He is working in Pune with Teradata Corp as a Senior Teradata Specialist on Teradata DWH projects. He has been associated with Teradata for more than 8 years and has successfully led multiple projects in various roles, with notable success in service delivery. He leverages Teradata and related technologies in the areas of database administration, workload, performance and cloud.

Summary:

Teradata, unlike other relational database management systems, is mainly popular because of its faster analytical processing and storage capabilities. This book unveils all the functionality offered by Teradata's analytical platform with the help of practical recipes. From installation to querying, indexing to loading utilities for analytical.

Contents:

Cover

Copyright and Credits

Dedication

Packt Upsell

Contributors

Table of Contents

Preface

Chapter 1: Installation

Setting up Teradata 15.10

How to do it...

Setting up Teradata Studio Express

Getting ready

Teradata on Azure

How it works...

There's more...

Defining a connection

Connecting to the Teradata system

Using Studio tool options

Setting up Teradata SQLA

Configuring SQLA

Building a query builder

Query builder in SQLA

Query builder in Express

Importing data

Getting started

In Express

Exporting data

How to do it

Chapter 2: SQLs

Introduction

Writing queries

Using SQLA

Using BTEQ in Windows

Querying efficiently

Explain before executing queries

Decoding explain

Resolving skewing data

See also

Resolving skew in database

Solving insert performance

Improving delete performance

Improving update performance

How it works.

There's more...

Performing MERGE INTO

Chapter 3: Advanced SQL with Backup and Restore

Backup and recovery

Exploring ordered analytic functions

Using CASE statements

Working with correlated subqueries

Experimenting with JSON

Partitioning tables column wise

Archiving data dictionary

Archiving databases

Archiving PPI tables

Restoring a table

Generating a unique row number

Chapter 4: All about Indexes

Creating a partitioned primary index to improve performance

Creating a join index to improve performance

Creating a secondary index to improve performance

Creating a hash index to improve performance

Chapter 5: Mixing Strategies - Joining of Tables

Introduction.

Identifying skewness in joins

Identify the right columns for joins

Eliminating product joins

Improving left join

Improving Teradata joins

Chapter 6: Building Loading Utility - Replication and Loading

Loading data from flat to Teradata

Resolving FastLoad error 2652

Using MultiLoad to delete

Resolving MLOAD error 2571

Resolving failure 7547

Upserting data using MLOAD

Loading data from a one Teradata Database to another

Chapter 7: Monitoring the better way

Configuring the viewpoint portlet

Identifying killer queries in viewpoint

Setting up viewpoint alerts

Changing and managing filters

Changing and managing throttle

Defining a ruleset

Creating a TASM exception

Chapter 8: Collect Statistics the Better Way

Cost-based optimizer

Evolution of statistics

How to collect statistics

Identifying stats for a table

Identifying multi-column stats

How to collect expression stats

How to copy statistics

Using help and show to resolve query issues

Recommendations

Chapter 9: Application and OPS DBA Insight

Creating, copying, and dropping tables

Working with views

Defining workloads based on application

Securing passwords using Teradata Wallet

Shrinking your data size

Using query band

Chapter 10: DBA Insight

Creating a Teradata database

Creating a Teradata database user

Creating profiles and assigning them to users

Creating a Secure Zone

Creating user accounts

Investigating phantom and leftover spool issues

Unlocking archive HUT locks

Chapter 11: Performance Tuning

Resolving a slow or hung system

Monitoring slow queries

Aborting a session from the supervisor window

Resolving AWT saturation

Identifying suspect queries

Managing DBC space

Optimizing queries

Chapter 12: Troubleshooting

Restarting the TD system

Insufficient memory to parse this request

Recovering AMP down

Performing scandisk on the system

Unlocking the DBC

There's more.

Managing the FSG cache.

Notes:

Includes index.

Description based on online resource; title from PDF title page (EBC, viewed March 8, 2018).

OCLC:

1024273637