Chris Adamson’s Blog

Information for BI & Analytics Professionals

Friday, October 22, 2010

Q&A: Star Schema and Referential Integrity

›
Two questions came in this week regarding referential integrity: Q: Regarding foreign keys (fact to dimension) do you think it is necessary...
Friday, October 15, 2010

Q&A: Degenerate Dimensions, ETL and BI

›
A question from a reader about including dimensions in the fact table: Q:  Question concerning an argument I am having with a colleague. W...
Friday, October 1, 2010

Q&A: Accumulating Snapshots

›
A reader asks about 1:1 relationships in a star schema. I am designing a superannuation data warehouse that will have a claims accumulating...
‹
›
Home
View web version
Powered by Blogger.