What iS PDE (Parallel Database Extension)?

a software interface layer on top of the operating
system that enables the database to operate in a
parallel environment.

Can you list different modules in Parsing Engine?

* Session controller
• Parser
• Optimizer
• Step Generator
• Dispatcher

what is UPSET command in teradata?

In Teradata, we can combine both UPDATE AND insert statements into
a single statement, we called it as UPSERT

what is the size of BYTEINT,SMALLINT,INTEGER?

BYTEINT - 1 Bytes - 8 bits -- > -128 to 127

SMALLINT - 2 bytes - 16 bites: ---> -32768 to 32767

INTEGER - 4 BYTES - 32 BITS ---> -2,147,483,648 to 2,147,483,647

How to see teradata version?

SELECT * FROM DBC.DBCINFO;

Is there any difference between user and database in teradata?

Database and a User are almost the same in Teradata because both can have Perm and Spool space, which allow them to hold objects. The only difference between a user and a database is that a user has a password and can logon and run queries.

A two-byte Partition number is added to the ROW-ID and it is now called a ROW KEY. The two-bytes per row will add more Perm Space to a table.

Joins to Non-Partitioned Tables can take longer and become more complicated for Teradata to perform.

Basic select queries utilizing the Primary Index can take longer if the Partition number is not also mentioned in the WHERE clause of the query.

You can't have a Unique Primary Index (UPI) if the Partition Number is not at least part of the Primary Index. You must therefore create a Unique Secondary Index to maintain uniqueness.