EncartaLabs

Teradata Utilities

( Duration: 1 Day )

Teradata Utilities Training course is designed to provide attendees with an in-depth knowledge of Teradata Utilities.

  • A mix of beginning, intermediate and advanced Teradata users

COURSE AGENDA

1

Introduction

  • The Teradata Utilities
  • Considerations for using block at a time utilities
  • Maximum amount of block utilities has changed!
  • Considerations for using row at a time utilities
  • Fast path inserts inside the teradata database
  • Fast path delete inside the teradata database
  • Freespace percent and loading tables
  • Referential integrity and load utility problems
  • V13 – no primary index tables
  • Nopi create statement
  • Nopi row-id increments the uniqueness value
  • Nopi row-hash different on each amp
  • Nopi options and facts
  • Nopi restrictions
2

BTEQ

  • Logging onto BTEQ interactively
  • Logging onto BTEQ in a script
  • Using BTEQ to submit queries in interactive mode
  • The brilliant BTEQ with by statement
  • Bteq can provide grand totals
  • The four types of BTEQ exports
  • A BTEQ export script
  • A BTEQ export script in report mode
  • Output for record mode and report mode
  • Using report mode to export a CSV file
  • Importing from a CSV file
  • Two ways to run a BTEQ script
  • Exporting large files in a unix mp-ras system
  • Bteq import script
  • Importing a comma separated CSV file
  • Multiple sessions in BTEQ
  • Fast path inserts using BTEQ
  • Cool commands in BTEQ – sidetitles
  • Using BTEQ conditional logic with errorcode
  • BTEQ commands
  • Sequence control commands
  • Format control commands
3

FastLoad

  • Maximum amount of block utilities has changed!
  • FastLoad has two phases
  • Acquisition phase 1
  • FastLoad application phase 2
  • A sample FastLoad script
  • Referential integrity and load utility problems
  • Two ways to execute a FastLoad script
  • Building, executing or scheduling FastLoad with Nexus
  • Building a FastLoad with nexus SmartScript
  • The SmartScript FastLoad builder
  • Executing FastLoad from the Nexus chameleon
  • Output report from FastLoad
  • Recovering when FastLoad fails
  • Valid data types used in FastLoad
  • FastLoad commands
4

MultiLoad

  • Maximum amount of block utilities has changed!
  • The five phases of MultiLoad
  • A sample MultiLoad script
  • Referential integrity and MultiLoad problems
  • Supported input formats
  • A MultiLoad that inserts and updates using
  • Two different input files
  • A MultiLoad that inserts and updates using
  • Two different input files continued
  • A MultiLoad that upserts
  • A MultiLoad that deletes
  • MultiLoad imports won‘t work with nopi tables
  • Two easy ways to run a MultiLoad
  • Building, executing or scheduling MultiLoad with nexus
  • Building a MultiLoad with nexus smartscript
  • The SmartScript MultiLoad builder
  • Executing your MultiLoad script
  • The output report from MultiLoad
  • Utility locks
  • Trouble shooting and restarting MultiLoad
  • TPump
  • Limitations of TPump
  • A sample TPump script
  • Two easy ways to run a TPump
  • Building, executing or scheduling TPump with Nexus
  • Building a TPump with nexus SmartScript
  • The SmartScript TPump builder
  • Executing your TPump script
  • Supported input formats
  • TPump script with error treatment options
  • A TPump script that uses two input data files
  • A TPump upsert sample script
  • Fundamentals of the .begin statement
  • Pack
  • Rate
  • Serialize
  • TPump commands and parameters
  • .begin load parameters unique to TPump
  • Monitoring TPump
  • Handling errors in TPump using the error table
  • Common error codes and what they mean
  • Restarting TPump
  • TPump and MultiLoad comparison chart
5

FastExport

  • Maximum amount of block utilities has changed!
  • How FastExport works
  • FastExport supported operating systems
  • FastExport
  • FastExport enhancement – no spool
  • A FastExport in its simplest form
  • FastExport script that joins two tables
  • FastExport modes and formats
  • How indicators can hurt your Fastload
  • How you can omit indicators in your FastExport
  • Create a Fastload with indicators
  • A FastExport script using binary mode
  • FastExport support and task commands
  • Task commands
  • FastExport supported SQL commands
  • Teradata Parallel Transport (TPT)
  • The TPT data stream flow
  • TPT operators
  • Read from multiple source files simultaneously
  • TPT operators and their functions
  • TPT operator types
  • TPT operators and their equivalent load utility
  • TPT operators and their purpose in life
  • How to run a TPT script
  • A sample BTEQ script for comparison
  • A TPT script for the DDL operator
  • Script sections
  • Schemas
  • Define statement in the declarative section
  • Processing statements in the executable section
  • Six syntax rules when creating TPT scripts
  • Build that job header and job name
  • Build that schema
  • Build that multiple schema
  • Build that producer operator
  • Build that consumer operator
  • Build that apply statement
  • Build that complex apply statement
  • Load operator and attributes
  • Loading a table from a flat file
  • Export operator select restrictions
  • Export attributes
  • Export a table to a delimited flat file
  • Export a table to a binary flat file
  • Loading to the employee table
  • The update operator
  • Script example of the update operator
  • The stream operator
  • Build that basic delete as a standalone
  • Build that complex delete as a standalone
  • Build that complex delete as a consumer task
  • Moving lob data through the sql inserter
  • TPT wizard
  • TPT utility commands
  • TBUILD commands
  • TLOGVIEW commands
  • V13 – expanded SQL in the DDL operator
  • V13 – to drop or not to drop
  • V13 – extra rows option for stream
  • V13 – TPT now supports blobs and clobs
  • V13 – period data type API support
  • V13 – temporal tables and TPT/API constraints
  • V13 – TBUILD – h option
  • V13 – operator type validation
6

INMOD Processing

  • What is an INMOD
  • Calling an INMOD from Fastload
  • Writing an INMOD
  • Writing an INMOD for Fastload
  • Writing for MultiLoad, TPump, and FastExport
  • Migrating an INMOD
  • Writing a notify routine
  • Sample INMOD
7

OUTMOD Processing

  • What is of an OUTMOD
  • How an OUTMOD works
  • Calling an OUTMOD from FastExport
  • Writing an OUTMOD
  • Writing a notify routine
  • Sample OUTMOD
8

Support Environment

  • The support environment commands
  • Required operational command list
  • Using a variable in a script
  • The support environment system variables
  • Support environment example

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top