sreedhar

• Oct 7th, 2005

 

its is not aggregate it is the alternate key

primary key : the column which is used for thr unique identification of a record from a table is called the primary key

alternate key : a column which is used for unique identification but not a primary key is called the alternate key

khurram

• Aug 3rd, 2006

 

aggregate fact tables have two types of keys

-composite key

-serrogate key (system generated key)

So aggregate-key is a primary key

psingla

 Profile Answers by psingla Questions by psingla

• Mar 8th, 2010

 

primary key:
is a key on ( 1  or group of columns) used to identify a record uniquely.
builds clustered index automatically

Alternate key:
is a key which is a unique key but not a primary key.
no clustered index builds automatically

surrogate key:
Its a another name for primary or altername key, if created on surrogate column(a column inserted artificially i.e. identity column).