A Secondary Index(SI) offers an alternative path to access the data. Unlike Primary Index which can only be defined at the time of table creation, a Secondary Index can be create/drop after the creation of the table also. There are … Read more »
Primary Index is the physical mechanism for storing and retrieving data row in Teradata AMP. Each table in Teradata must have at least one column as Primary Index. It is defined at the time of creating table. If any change in … Read more »
Each column in a table is associated with a data type. Data types simply denote the type of data that we can store in any particular column. For example, for storing string data like “James” into a column we need … Read more »
Teradata users or any other applications submit a query in the form of SQL (Structure Query Language) and receive the answer. But behind the scene, it has to pass many tests which determine its fate. Below are the steps which … Read more »
It may come to your mind that how many Nodes, Amps, PEs are there in your development and production Teradata system in which you are working on daily basis. Know your Teradata system configuration as below. To check the Teradata system … Read more »
In this tutorial, we will guide you on how to connect Teradata SQL Assistant to the Teradata Database using Teradata ODBC Driver and other methods. If you want to install Teradata Database in Windows, you can check out our tutorial … Read more »
Do you want to install Teradata in your PC and start practicing today? Here is the Teradata installation guide with screenshots. Teradata releases pre-installed image for Teradata Express for Vmware Workstation/Player. By installing this, you can access teradata from your … Read more »
The main components of Teradata Architecture are PE(Parsing Engine), BYNET, AMP(Access Module Processor), Virtual Disk. Following is the logical view of the architecture: Parsing Engine When a user fires an SQL query it first gets connected to the PE (Parsing … Read more »
What is Teradata? Teradata is a RDBMS (relational database management system) which includes below features: It’s built on completely parallel architecture which means single task will be divided into smaller chunks and compute simultaneously hence faster execution. Teradata system is … Read more »