Q

Composite keys in fact tables

Is it a good approach to use a composite key in a fact table linking to a dimensional table?

Is it a good approach to use a composite key in a fact table linking to a dimensional table?
The fact that a fact table contains a composite key (a primary key that is made up of multiple parts) that links to a dimension table is exactly the approach that is used within dimensional modeling. All fact tables are made up of a composite key to a dimension table, thereby defining the grain of the table, and this then links to the key within the dimension table.
This was first published in September 2005

Dig deeper on Oracle and SQL

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close