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 »
BTEQ EXPORT:- Record/DATA mode- This is set by .EXPORT DATA. In this mode data will be written to flat file in native format i.e. INTEGER data is written as a 4 bytes binary field. It cannot be read and understood … Read more »
BTEQ, stands for Basic Teradata Query and pronounced as bee-teeek, is a general purpose, command driven utility that enables user to interact with one or more Teradata Database Systems. Teradata BTEQ allows to perform below tasks- Can submit SQL in … Read more »
Algorithmic Compression (ALC), a new compression technique introduced in Teradata 13.10, is mainly designed for compressing data with well-know columns. Teradata provides a few built in ALC algorithms. For example, to compress Unicode column data Teradata provided TransUnicodeToUTF8 algorithm. Apart … Read more »
Block Level Compression (BLC) is a space reduction technique in Teradata. It has been introduced in 13.10 and is used to apply compression to all the permanent data blocks in a table. The compression rate can be achieved by this … Read more »
We all know that now-a-days how many transactions are happening per day in this digital world. To store those data in data warehouse we need more storage disk. So everyone is looking for reducing the cost of storing data. One … Read more »
RAID is a technology that uses multiple physical disk drives to protect data from a single disk failure. The purpose of RAID is to ensure that at the time of failure, there should be one copy of data which should … Read more »
Whenever the user executes any query, Teradata creates different execution plans and chooses the best plan to execute the SQL query. These execution plans are based on the statistics collected on the tables used within the SQL query. The information … Read more »