Category: TD Basics

Primary Index in Teradata

primary index in teradata, hashing, hashing algorithm, row hash value, data distribution in teradata, UPI and NUPI

Recovery Journal

Recovery Journal in teradata, transient journal, down amp recovery journal, permanent journal, journal recovery

Teradata Space Management

teradata space allocation, permanent space, spool space, temp space, global temporary tables, PERM space, SPOOL space,

Teradata Background Check

The Teradata database was originally designed in 1976, by TERADATA Corp. Nearly 25 years later, Teradata is still considered ahead of its time. In 1976, IBM, mainframes dominated the computer business. However the original founders of TD noticed that it took about 4½ years for IBM to produce a new mainframe. At the same time, …

Continue reading

Components of Teradata

Teradata is made up of following components – Processor Chip – The processor is the BRAIN of the Teradata system. It is responsible for all the processing done by the system. All task are done according to the direction of the processor. Memory – The memory is known as the HAND of the Teradata system. …

Continue reading

Teradata Architecture

Teradata Architecture is the key component to learn Teradata.

Limitations of FAST LOAD

limitation of fastload, fastload, teradata utilities, secondary index