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 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 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 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 »
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 »
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 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 »
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 »
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 »