Teradata FastLoad

From Wikipedia, the free encyclopedia
Jump to: navigation, search

FastLoad is a Teradata utility.

Teradata FastLoad – Initial Table Load[edit]

This 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 many client platforms, mainframe, or load server to move data into the Teradata Database.

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

Features[edit]

  • Initial table load
  • Delimited or fixed format input

Description[edit]

FastLoad is a command-driven utility to load large data into 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
  • User defined input module (INMOD) routines to select, validate, and preprocess input data
  • Any other device providing properly formatted source data

FastLoad uses multiple database sessions to load data.

Constraints on the use of fastload are

  • the target table must be empty
  • no access (read or write) is allowed on the target table while loading
  • only a single table can be loaded in one job

An alternative to fastload is MultiLoad which does not have the above restrictions, but also has a significantly slower load performance.

Supported Platforms[edit]

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

A Sample Script[edit]

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[edit]

See also[edit]