8247  Reviews star_rate star_rate star_rate star_rate star_half

Teradata Load Utilities

Accelebrate's Teradata Load Utilities training course teaches attendees to use Teradata's wide array of efficient, scalable, and flexible features to seamlessly stream data from different sources...

Read More
Course Code TER-140
Duration 3 days
Available Formats Classroom

Accelebrate's Teradata Load Utilities training course teaches attendees to use Teradata's wide array of efficient, scalable, and flexible features to seamlessly stream data from different sources into one central system.

Skills Gained

  • Collect Statistics
  • Table Create and Data Types
  • Temporary Tables
  • BTEQ – Batch Teradata Query
  • FastLoad
  • MultiLoad
  • TPump
  • FastExport
  • Teradata Parallel Transport (TPT)
  • The major keys to building TPT scripts
  • TPT utility commands
  • How to run a TPT script
  • TPT operators and their equivalent load utility
  • Teradata best practices

Prerequisites

No prior experience is required.

Course Details

Training Materials

All Teradata training students receive comprehensive courseware.

Software Requirements

We have multiple options for setting up this course using a mix of local and/or cloud resources that we provide. Please ask us for details.

Outline

  • Introduction
  • Teradata Utilities Introduction
  • Collect Statistics
  • Table Create and Data Types
  • Temporary Tables
  • BTEQ – Batch Teradata Query
  • FastLoad
  • MultiLoad
  • TPump
  • FastExport
  • Teradata Parallel Transport (TPT)
  • Top SQL Commands Cheat Sheet
  • Conclusion