Nov 20
Each table in Teradata is required to have a primary index.Even if you did not define any primary index in CREATE table statement, the Teradata system will automatically create the primary index based on the setting of DBScontrol setting field . The primary index defines where data will reside and which AMP receives the row. …
Apr 18
The Teradata database uses Recovery Journal to automatically maintain data integrity in the case of : An interrupted transaction An AMP failure Recovery Journals are created, maintained and purged by the system automatically, so no DBA intervention is required. Recovery journal are tables stored in the storage medium so they take up the disk space …
Mar 05
Teradata is designed in such a fashion, to reduce the DBA’s administrative functions when it comes to space management. Space is configured in the following ways in Teradata system – 1) PERMANENT SPACE 2) SPOOL SPACE 3) TEMPORARY SPACE 1) PERMANENT SPACE – Permanent space is where the objects (i.e. – databases, users, tables) are …
Feb 26
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, …
Feb 24
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. …
Feb 24
The biggest strength of the Teradata is the parallelism. So the architecture of the Teradata is designed in such way to keep this strength in mind. Teradata is unique from any other database because of its unique architecture only. The main components of Teradata architecture is PE (Parsing Engine), AMP (Access Module Processor) and BYNET …
Feb 23
There are few limitations which we have on Fastload. These limitations are necessary for Fastload to load data with the lightning fast speed into tables. NO SECONDARY INDEXES ARE ALLOWED ON TARGET TABLE – Fastload can load tables only with primary indexes defined on it. If we have a secondary index on the table then …
