Teradata FastLoad

FastLoad is a Teradata utility.

Teradata FastLoad – Initial Table Load

This highly reliable, parallel load utility is designed to move large volumes of data – collected from data sources on channel and network-attached clients – into empty tables in the Teradata Database. You can execute Teradata FastLoad from any client platform, mainframe, or load server to move data seamlessly into the Teradata Database.

And because data allocation, conversion, movement, and loading are automatic and performed in parallel, FastLoad offers higher performance levels than a standard application program written to load data to an empty database.

Features

• High-performance initial table load

Description

FastLoad is a command-driven utility you can use to quickly load large amounts of data in an empty table on a Teradata Relational Database Management System (RDBMS).

You can load data from:

• Disk or tape files on a channel-attached client system
• Input files on a network-attached workstation
• Special input module (INMOD) routines you write to select, validate, and preprocess input data
• Any other device providing properly formatted source data

FastLoad uses multiple sessions to load data. However, it loads data into only one table on a Teradata RDBMS per job. If you want to load data into more than one table in an RDBMS, you must submit multiple FastLoad jobs—one for each table.

Supported Platforms

• NCR UNIX SVR4 MP-RAS™
• IBM z/OS (MVS)
• Microsoft® Windows® 2000, XP, and Server 2003
• Sun Solaris SPARC
• HP-UX
• IBM AIX
• RedHat Linux
• SUSE Linux Enterprise Server from Novell

A Sample Script

sessions 2;
errlimit 25;
logon tdpid/username,password;


CREATE TABLE employee (
  EmpNo SMALLINT FORMAT ‘9(5)’ BETWEEN 10001 AND 32001 NOT NULL,
  Name VARCHAR(12),
  DeptNo SMALLINT FORMAT ‘999’ BETWEEN 100 AND 900 ,
  PhoneNo SMALLINT FORMAT ‘9999’ BETWEEN 1000 AND 9999,
  JobTitle VARCHAR(12),
  Salary DECIMAL(8,2) FORMAT ‘ZZZ,ZZ9.99’ BETWEEN 1.00 AND 999000.00 ,
  YrsExp BYTEINT FORMAT ‘Z9’ BETWEEN -99 AND 99 ,
  DOB DATE FORMAT ‘MMMbDDbYYYY’,
  Sex CHAR(1) UPPERCASE,
  Race CHAR(1) UPPERCASE,
  MStat CHAR(1) UPPERCASE,
  EdLev BYTEINT FORMAT ‘Z9’ BETWEEN 0 AND 22,
  HCap BYTEINT FORMAT ‘Z9’ BETWEEN -99 AND 99 )
  UNIQUE PRIMARY INDEX( EmpNo ) ;

set record unformatted;
define
  delim0(char(1)),
  EmpNo(char(9)), delim1(char(1)),
  Name(char(12)), delim2(char(1)),
  DeptNo(char(3)), delim3(char(1)),
  PhoneNo(char(4)), delim4(char(1)),
  JobTitle(char(12)), delim5(char(1)),
  Salary(char(9)), delim6(char(1)),
  YrsExp(char(2)), delim7(char(1)),
  DOB(char(11)), delim8(char(1)),
  Sex(char(1)), delim9(char(1)),
  Race(char(1)), delim10(char(1)),
  MStat(char(1)), delim11(char(1)),
  EdLev(char(2)), delim12(char(1)),
  HCap(char(2)), delim13(char(1)),
  newlinechar(char(1))
file=insert.input;

show;

begin loading employee errorfiles error_1, error_2;
insert into employee (
  :EmpNo,
  :Name,
  :DeptNo,
  :PhoneNo,
  :JobTitle,
  :Salary,
  :YrsExp,
  :DOB,
  :Sex,
  :Race,
  :MStat,
  :EdLev,
  :HCap
);
  
end loading;
logoff;

External links

• Teradata Load & Unload Utilities