ReadVitamin

Creating Tables with SET and MULTISET

When creating tables in Teradata, it is important to consider whether or not you want to allow duplicate values in the table. The SET and MULTISET clauses are used in CREATE TABLE statement in Teradata with characteristics to allow duplicate in the table or NOT. If you specify SET, which adheres to relational data model, it will NOT allow duplicate rows in a table. On the other hand, MULTISET concept follows multidimensional data model and [+]

A Brief Introduction On Teradata.

Teradata Corporation is a global leader in providing data warehousing technologies. Almost all of the largest data warehouses on earth use Teradata RDBMS. Teradata was formerly a division of NCR Corporation with their headquarters in Dayton. They spin-off from NCR on October 1, 2007 and now a truly technology oriented company. Teradata is a complete relational database management system with its massively parallel processing mechanism running on distributed computing architecture which is scalable in all dimensions [+]