Mar 21
Advantage of Partition Primary Index – Partitioned Primary Index is one of the unique features of Teradata, which is used for distribution of rows based on different partitions so that they can be retrieved much faster than any other conventional approach. Maximum partitions allowed by Teradata – 65,535 It also reduces the overhead of scanning the complete …
Feb 25
Partitioned primary index or PPI is used for physically splitting the table into a series of subtables. With the proper use of Partition primary Index we can save queries from time consuming full table scan. Instead of scanning full table, only one particular partition is accessed. Follow the example below to get the insight of PPI – …
Jan 17
What is Compression in Teradata Compression is the feature of Teradata which helps to reduce the disk storage. It is useful in reducing the disk space required by FIXED LENGTH columns or NULLS. It is a loss less compression so no data will be lost in it. We can do compression on the following data …
Oct 16
Fastload Commands Given below is the list of Fastload commands which is extensively used in creation of Fastload scripts. ERRLIMIT Specifies the maximum number of rejected ROWS allowed in error table 1 (Phase I). LOGON/LOGOFF or, QUIT LOGON begins a session. LOGOFF ends a session. QUIT is the same as LOGOFF. NOTIFY NOTIFY command used …
Oct 13
A sample Fastload script Below is the sample Fastload script which is designed to work in WINDOWS OS. To run the Fastload in your system you need to install Fastload utility and then go to command prompt and type – >fastload < c:\fload_1.txt where c:\fload_1.txt is the name and path of the Fastload which you want to execute. A sample Fastload script /***** Section 1 *****/ …
Oct 06
Phases of Fastload Fastload divides its job into two phases 1) Phase 1 – Acquisition 2) Phase 2 – Application Phase 1 – Acquisition The main objective of this phase is to send rows of data file from HOST computer to Teradata AMPs as fast as possible. Rows of the data file are packed into …
Oct 06
Introduction Fastload is the Teradata utility which can be used to load large amount of data in empty table on a Teradata System. The property which makes Fastload UNIQUE is its fast speed to load huge amount of data in tables. You can load data from – Disk or Tape drives from the channel attached …
