Is it a must for FACT tables to have all its FKs columns form the Primary Key ?
2 posters
Page 1 of 1
Is it a must for FACT tables to have all its FKs columns form the Primary Key ?
Hi ,
Came across this here :
http://www.kimballgroup.com/1996/09/02/factless-fact-tables/
while i was reading on Factless Fact tables. [Ist para]
Why is this recommended ? Is it because Roll up and Drill downs will be faster if we have the FK columns coming from the Dimensions as the Primary Key thereby automatically creating indexes for these columns in the FACT (by the target DB) , thereby improving performance ?
Or are there any other reasons ?
Regards,
Karan
Fact tables always have a multipart key, in which each component of the key joins to a single dimension table.
Came across this here :
http://www.kimballgroup.com/1996/09/02/factless-fact-tables/
while i was reading on Factless Fact tables. [Ist para]
Why is this recommended ? Is it because Roll up and Drill downs will be faster if we have the FK columns coming from the Dimensions as the Primary Key thereby automatically creating indexes for these columns in the FACT (by the target DB) , thereby improving performance ?
Or are there any other reasons ?
Regards,
Karan
karan_das- Posts : 10
Join date : 2013-02-26
Age : 37
Re: Is it a must for FACT tables to have all its FKs columns form the Primary Key ?
No, there is no reason to use or declare primary keys for facts unless a particular DBMS can take some advantage of it.
Besides, the primary key is not always 'all the keys'. A primary key compound index will not usually help queries (but it depends on which database). On most databases, it is a hinderance
Besides, the primary key is not always 'all the keys'. A primary key compound index will not usually help queries (but it depends on which database). On most databases, it is a hinderance
Similar topics
» Can a FACT table contains Natural Primary keys and text columns
» Number of Columns in Fact Tables vs. Dimension Tables
» Primary Key of Dimension and Fact Tables
» Free Form Text Attribute in Fact Table
» Modelling question - Multiple fact tables with one to many relationships and querying from many fact tables
» Number of Columns in Fact Tables vs. Dimension Tables
» Primary Key of Dimension and Fact Tables
» Free Form Text Attribute in Fact Table
» Modelling question - Multiple fact tables with one to many relationships and querying from many fact tables
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum