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 »
A Sample Fastload script /*Section 1*/ .SESSIONS 50; /*Section 2*/ .LOGON IP_Adress/username,password; /*Section 3*/ drop table TERADATAPOINT.STUDENT; drop table TERADATAPOINT.STUDENT_E1; drop table TERADATAPOINT.STUDENT_E2; CREATE MULTISET TABLE TERADATAPOINT.STUDENT ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT, DEFAULT … Read more »
Teradata Fastload is a command driven utility which can be invoked either in batch or interactive mode and used to load large volume of data into Teradata empty table. Teradata Fastload utility establishes multiple session i.e. one session per AMP … Read more »
Teradata BTEQ Script for import /*Section 1*/ .logon 192.168.106.2/teradatapoint,teradatapoint; /*Section 2*/ CREATE SET TABLE teradatapoint.employee ,NOFALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM=DEFAULT, DEFAULT MERGEBLOCKRATIO ( emp_IDINTEGER, emp_nameVARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC, mgr_IDINTEGER) PRIMARY INDEX( emp_ID ); .IMPORT DATA FILE=C:\teradatapoint\import_data.txt; /*Section 3*/ .QUIET ON … Read more »