How many table can you join in a single query in teradata?

Teradata can join up to 64 tables in a single query.

What is the difference between a PRIMARY KEY and a PRIMARY INDEX?

A Primary Key is a logical term used to label column(s) that enforce the uniqueness of each row in a table. PKs determine relationships among tables. A Primary Index is a physical term used to label column(s) that is used to store and locate rows of data

Does every table has primary index in Teradata?

PI is so important to Teradata functionality that every table in the database is required to have one
The Main uses of PI are

1. The Primary Index WILL DETERMINE which rows go to which AMPs; and

2. The Primary Index is ALWAYS the FASTEST RETRIEVAL method.

if the user doesn't define a PRIMARY INDEX when creating a table, the system will automatically choose one by default. Once it is defined, the PI column cannot be dropped or changed. The table would need to be re-created in order to change the PI.

What is BYNET in teradata?

the Bynet is an internal Teradata network over which the PEs and the AMPs communicate

What forms the relationship between the tables in a relational database?

A key that is common to each table forms it. A "Foreign Key (FK)" is a key in a table that is a Primary Key (PK) in another table. The PK and FK relationship allows the two tables to relate to one anothe

can you list some vendors in data mining?

SAS , SPSS, IBM Intelligent Miner, Microsoft SQL server data mining, oraclem, Angoss,KXEN

what is data mining?

data mining is about analyzing data and finding hidden patterns using automatic or semiautomatic ways/methods

data mining is key member in Business Intelligence product family