Technical Posts like Teradata , UNIX, Data Warehousing Concepts, SQL Concepts etc
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 be
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.
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 is