FastLoad


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.

upported 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

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

* [http://www.teradata.com/t/page/94244/index.html/ Teradata Load & Unload Utilities]

ee also


Wikimedia Foundation. 2010.

Look at other dictionaries:

  • Epyx FastLoad — The Epyx FastLoad is a floppy disk fast loader cartridge made by American software company Epyx in 1984 for the Commodore 64 home computer. It was programmed by Epyx employee Scott Nelson, who later designed the Epyx Vorpal fastloading system for …   Wikipedia

  • Commodore 64 peripherals — Commodore 64 Home Computer This article is about the various external peripherals of the Commodore 64 home computer. Contents 1 Storage …   Wikipedia

  • Epyx — Infobox Company company name = Epyx, Inc. company company type = Corporation foundation = 1978 (as Automated Simulations) (defunct 1993) location = San Francisco, California key people = Jim Connelley Jon Freeman area served = industry = Computer …   Wikipedia

  • Teradata Parallel Transporter — (TPT) is a Teradata utility.Teradata Parallel TransporterTeradata Parallel Transporter, a parallel multi function load environment, simplifies building and maintaining a data warehouse by providing flexible, scalable access to data sources from a …   Wikipedia

  • Commodore 1541 — Front view of the most common version of the Commodore 1541 disk drive, with open disk slot. This version uses a Newtronics drive mechanism, and the rotating lever is used to hold the disk in place …   Wikipedia

  • Sonny Liston — Liston in 1963 Statistics Real name Charles L. Liston Nickname(s) Sonny The Big Bear …   Wikipedia

  • Teradata — Infobox Company company name = Teradata Corporation company type = Public (NYSE: [http://www.nyse.com/about/listed/lcddata.html?ticker=TDC TDC] ) company slogan = Raising Intelligence foundation = 1979 location = key people = Michael Koehler,… …   Wikipedia

  • Commodore BASIC — Commodore BASIC, also known as PET BASIC, is the dialect of the BASIC programming language used in Commodore International s 8 bit home computer line, stretching from the PET of 1977 to the C128 of 1985. The core was based on 6502 Microsoft BASIC …   Wikipedia

  • Disk editor — A disk editor is a computer program that allows its user to read, edit, and write raw data (at character or hexadecimal, byte levels) on disk drives (e.g., hard disks, USB flash disks or removable media such as a floppy disks); as such, they are… …   Wikipedia

  • Commodore DOS — Commodore DOS, aka CBM DOS, was the disk operating system used with Commodore s 8 bit computers. Unlike most other DOS systems before or since which are booted from disk into the main computer s own RAM at startup, and executed there CBM DOS was… …   Wikipedia