Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / General / Data Warehousing / April 2008

Tip: Looking for answers? Try searching our database.

pk's on a fact table in a data warehouse

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Joe H - 10 Apr 2008 17:08 GMT
Looking at M$ and Kimball examples - I don't see any of them defining a PK
inside the fact tables.  Isn't this bad since it won't offer integrity and
allow duplicates to be inserted?
Jeje - 10 Apr 2008 17:50 GMT
it's the job of the ETL process to do the cleansing and detect the errors.
and, in the idea of filling a cube after the DW, indexes are not required
and slow down the loading process of the database.
filling a cube doesn't required any index, it's a full scan read process.

it's why they don't talk about PK.
but it's your choice, In my case I'm using PK on the fact tables because I
have to produce reports based on the leaf level of my fact table.

> Looking at M$ and Kimball examples - I don't see any of them defining a PK
> inside the fact tables.  Isn't this bad since it won't offer integrity and
> allow duplicates to be inserted?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.