Teradata FAQ’s

Some of the ETL tools which are commonly used in Teradata are DataStage, Informatica, SSIS, etc.

The primary characteristics of Teradata are :

• Is capable of running on Single-nodes, as well as multi-nodes.
• Parallelism is built into the system.
• Very much compatible with the standards of ANSI.
• Tends to act in the same way as a server.
• It is an Open System that basically executes for UNIX MR-RAS, Suse Linux ETC, WIN2K, etc.

Some of the newly developed features of Teradata are: -

• Automated temporal analytics
• Extension in the compression capabilities which allows flexible compression of data about 20 times more data than the previous version.
• Customer associated innovation like tetradata viewpoint.

Caching is considered as an added advantage of using Teradata as it primarily works with the source which stays in the same order i.e. does not change on a frequent basis. At times, Cache is usually shared amongst applications.

We can check the version of Teradata by just giving the command .SHOW VERSION.

The index sub-table row happens to be on the same Amp in the same way as the data row in NUSI. Thus, each Amp is operated separately and in a parallel manner.

The script has to be submitted manually so that it can easily load the data from the checkpoint that comes last.

A node basically is termed as an assortment of components of hardware and software. Usually a server is referred to as a node.

Parsing is a process concerned with analysis of symbols of string that are either in computer language or in natural language.

PDE stands for Parallel Data Extension. PDE basically happens to be an interface layer of software present above the operation system and gives the database a chance to operate in a parallel milieu.

TPD stands for Trusted Parallel Database, and it works under PDE. Teradata happens to be a database that primarily works under PDE. This is the reason why Teradata is usually referred to as Trusted Parallel or Pure Parallel database.

SMP technology is related to hardware. The hardware that supports Teradata database software is based on SMP (Symmetric multiprocessing) technology. The hardware can be combined with a communications network that connects the SMP systems to form MSP (Massively Parallel Processing) systems.

A channel driver is software that acts as a medium of communication between PEs and all the applications that are running on channels which are attached to the clients.

Just like channel driver, Teradata Gateway acts as a medium of communication between the Parse Engine and applications that are attached to network clients. Only one Gateway is assigned per node.

UPSERT basically stands for Update Else Insert. This option is available only in Teradata.

Index table facilitates with the faster and efficient search of the record.

Virtual Disk is basically a compilation of a whole array of cylinders which are physical disks. It is sometimes referred to as disk Array.

BYNET serves as a medium of communication between the components. It is primarily responsible for sending messages and also responsible for performing merging, as well as sorting operations.

Some of its newly developed features are as follows.

• Automated temporal analytics.
• JavaScript object Notation
• Teradata QueryGrid
• XML Data Type
• Performance
• Data Compression
• Customer associated innovation like Teradata viewpoint.