FastLoad

From Wikipedia, the free encyclopedia

This article or section is written like an advertisement. Please help rewrite this article from a neutral point of view. Mark blatant advertising which would require a fundamental rewrite in order to become encyclopedic for speedy deletion, using {{db-spam}}. (December 2007)

FastLoad is a Teradata utility.

Contents 1 Teradata FastLoad – Initial Table Load 2 Features 3 Description 4 Supported Platforms 5 A Sample Script 6 External links 7 See also

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

A nd 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.

[edit] Features

• High-performance initial table load

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

[edit] 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
• Red Hat Linux
• SUSE Linux Enterprise Server from Novell

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

[edit] External links

• Teradata Load & Unload Utilities

[edit] See also