Teradata Drop Database

Teradata Drop Database statement is used to drop an empty database from the Teradata system. Before dropping a database in Teradata below point should be noted: The user you are using to drop a database should have the appropriate privileges … Read more »


Teradata CREATE DATABASE A Teradata database is a local repository for various kinds of database objects like Tables (requires perm space), Views (uses no perm space), Procedures (requires perm space), functions, etc. Teradata CREATE DATABASE syntax  Below is the syntax … Read more »

Teradata FastExport – Part 2

Teradata FastExport Sample Script   .LOGTABLE MYDB.STUDENT; /* define restart log */ .LOGON ip_address/username,password; /* DBC logon string*/ .BEGIN EXPORT SESSIONS 10; /* begin export with number of sessions to be used */ .EXPORT OUTFILE filepath/output.txt mode record format text; … Read more »

Teradata FastExport – Part 1

Teradata Fastexport is a command driven utility that uses multiple sessions to transfer data from tables or views to client system. Why it is called “FAST”export? We have Teradata BTEQ in place for exporting the data then why should one … Read more »

Teradata MultiLoad – Part 4

Teradata MultiLoad commands can be divided into below two categories- Support activities- Teradata commands establish MultiLoad sessions with Teradata database and create a support environment for Teradata MultiLoad. Task activities- Theses commands specify the actual processing that takes place for … Read more »

Teradata MultiLoad – Part 3

A Sample Teradata MultiLoad script /*Section 1*/.LOGTABLE TERADATA.STUDENT_log;/*Section 2*/.logon IP_Address/username,password; /*Section 3*/.BEGIN IMPORT MLOAD         TABLES       TERADATA.STUDENT         WORKTABLES   TERADATA.STUDENT_log_wt         ERRORTABLES  TERADATA.STUDENT_log_et                                      TERADATA.STUDENT_log_uvAMPCHECK ALL; /*Section … Read more »

Teradata MultiLoad – Part 2

MultiLoad IMPORT has five phases. Phase 1: Preliminary Phase Parses and validates all Teradata MultiLoad commands and Teradata SQL statements. Establishes MultiLoad sessions with the Teradata database. The default is the number of available AMPs. For a small system the … Read more »

Teradata MultiLoad – Part 1

Teradata MultiLoad  or MLoad is a command driven load utility for fast, high volume data maintenance on multiple tables or views in Teradata database. Why it is called Multi-load? MultiLoad  can perform multiple DML operations, including INSERT, UPDATE, DELETE, and … Read more »

Teradata FastLoad – Part 4

FastLoad Commands:- Teradata FastLoad commands can be divided into two types – Session control commands:-  LOGON  Begins one or more FastLoad session  LOGOFF/QUIT  Ends FastLoad sessions and terminate Teradata FastLoad  SESSIONS  Specifies the number of Teradata FastLoad sessions to be … Read more »

Teradata FastLoad – Part 3

Limitation of FastLoad:- FastLoad has few limitations. Many of these restrictions help FastLoad to load data in lightning fast in Teradata table. No Secondary Index–Teradata FastLoad does not support any secondary index on the target table.  This is because secondary … Read more »