In Teradata , LOCKS are used to maintain integrity of data present in the tables. Teradata , itself decides the kind of lock to implement however in some cases users can also decide what kind of lock, the query should use. In TERADATA, locks can beRead More →

Tables are two-dimensional representation of data in rows & columns. Tables form the core of any RDBMS environment. In TERADATA, Table creation is not as straightforward as it looks. You can create Tables withRead More →

TERADATA has three kinds of Storage Space namely PERMANENT, SPOOL and TEMPORARY. Permanent Space is used for storing permanent date like Permanent Tables, Secondary Indexes and Permanent Journals. SoRead More →

Teradata uses a HASHING algorithm to distribute rows among various AMP’s. The process of rows distribution is unique to Teradata and obviously is the core reason behind the parallel architecture of TERADATA. To understand the process of Rows Distribution , refer to below diagram.Read More →

TERADATA is a Database server which can handle multiple clients concurrently. Teradata is a RDBMS (Relational Database Management System) which is strongly recommended for handling huge data warehouse environment. The unique feature of Teradata isRead More →