Mar 21

Partition Primary Index – Advantage and Disadvantage

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 …

Continue reading »

Feb 25

Partition Primary Index – Basics

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 – …

Continue reading »

Jan 17

Compression in Teradata

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 …

Continue reading »

Oct 13

Teradata Utilities – FASTLOAD part 3

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 *****/ …

Continue reading »

Oct 06

Teradata Utilities – FASTLOAD part 2

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 …

Continue reading »

Oct 06

Teradata Utilities – FASTLOAD part 1

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 …

Continue reading »

Older posts «

» Newer posts