Teradata Load Utilities
eBook - ePub

Teradata Load Utilities

  1. 394 pages
  2. English
  3. ePUB (mobile friendly)
  4. Available on iOS & Android
eBook - ePub

Teradata Load Utilities

About this book

This book covers all of the traditional utilities at the perfect level with detailed examples and explanations so they're clear to understand. It then explains TPT perfectly with an example of everything! It covers traditional utilities, BTEQ, FastLoad, MultiLoad, TPump, FastExport, and then all of the TPT scripts that do all of the different aspects of those utilities with real world examples that work.

Frequently asked questions

Yes, you can cancel anytime from the Subscription tab in your account settings on the Perlego website. Your subscription will stay active until the end of your current billing period. Learn how to cancel your subscription.
No, books cannot be downloaded as external files, such as PDFs, for use outside of Perlego. However, you can download books within the Perlego app for offline reading on mobile or tablet. Learn more here.
Perlego offers two plans: Essential and Complete
  • Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
  • Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Both plans are available with monthly, semester, or annual billing cycles.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes! You can use the Perlego app on both iOS or Android devices to read anytime, anywhere — even offline. Perfect for commutes or when you’re on the go.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Yes, you can access Teradata Load Utilities by Tom Coffing,Todd Wilson in PDF and/or ePUB format, as well as other popular books in Computer Science & Data Warehousing. We have over one million books available in our catalogue for you to explore.

Chapter 1 - Teradata Utilities Introduction

“I don't know who my grandfather was. I am more interested in who his grandson will become.”
– Abraham Lincoln, President of the United States
The Teradata Utilities
images
BTEQ – The first Teradata query tool. It imports and exports data and should be used when < 500,000 rows. BTEQ is an excellent report writer.
images
FastLoad performs Inserts into empty Teradata tables in 64K blocks. There can be NO Secondary Indexes, Triggers, Referential Integrity, or Join Indexes on the table.
images
MultiLoad loads to populated Teradata tables in 64K blocks. MultiLoad supports Inserts, Updates, Deletes, and Upserts. There can be NO Unique Secondary Indexes, Triggers, Referential Integrity, or Join Indexes on the table.
images
TPump loads into Empty or Populated Tables and is a lot like MultiLoad except TPump does all of the work at the row level and NOT the block level. It is called TPump because you can turn up or down the pump to increase or decrease the load quantities, and it allows Secondary Indexes, Referential Integrity, Triggers, or Join Indexes.
images
FastExport – Exports data off of Teradata at the block level. It is much faster than a BTEQ Export and is used for exports when there are more than 500,000 rows exported.
images
TPT – The Teradata Parallel Transport is one scripting language that combines all of the above utilities into one common utility.
Above are the utilities and their specialties.
Block Level Utilities
images
FastLoad performs Inserts into empty Teradata tables in 64K blocks.
images
MultiLoad loads to populated Teradata tables in 64K blocks.
images
FastExport – Exports data off of Teradata at the 64K block level.
No Secondary Indexes (FastLoad)
No Unique Secondary Indexes (FastLoad and MultiLoad)
No Triggers (FastLoad and MultiLoad)
No Join Indexes (FastLoad and MultiLoad)
No Referential Integrity (FastLoad and MultiLoad)
Only 30 FastLoad and MultiLoad combinations can run at one time.
Only 60 FastExport jobs can run simultaneously!
The block utilities have limits that prevent too many of them running at the same time. This feature is actually controlled by a new DBS Control parameter named MaxLoadAWT which controls AMP Worker Tasks (AWT). When MaxLoadAWT is set to zero, then it is like going back in time to pre-V2R6.0 where only 15 FastLoad, MultiLoad, and FastExport jobs can run, max.
Row Level Utilities
images
BTEQ – The first Teradata query tool. It imports and exports data and should be used when < 500,000 rows. BTEQ is an excellent report writer.
images
TPump loads into Empty or Populated Tables and is a lot like MultiLoad except TPump does all of the work at the row level and NOT the block level. It is called TPump because you can turn up or down the pump to increase or decrease the load quantities.
Secondary Indexes allowed
Triggers allowed
Join Indexes allowed
Referential Integrity allowed
You can have an unlimited amount of TPump and BTEQ utilities running simultaneously!
Row Level Utilities are not as fast as block level utilities, but they are really flexible and easy to implement. There are almost no restrictions.
Fast Path Inserts Using Insert/Select
images
Why is the Fast Path so fast?
  1. Only one write to the Transient Journal (Now ca...

Table of contents

  1. Cover Page
  2. Title Page
  3. Copyright Page
  4. About Tom Coffing
  5. About Todd Wilson
  6. Contents
  7. Chapter 1 - Teradata Utilities Introduction
  8. Chapter 2 - Collect Statistics
  9. Chapter 3 - Table Create and Data Types
  10. Chapter 4 - Temporary Tables
  11. Chapter 5 - BTEQ – Batch Teradata Query
  12. Chapter 6 - FastLoad
  13. Chapter 7 - MultiLoad
  14. Chapter 8 - TPump
  15. Chapter 9 - FastExport
  16. Chapter 10 - Teradata Parallel Transport (TPT)
  17. Chapter 11 - Top SQL Commands Cheat Sheet
  18. Back Cover